troubleshooting Question

Count based on a date

Avatar of LUIS FREUND
LUIS FREUND asked on
Microsoft OfficeMicrosoft Excel
3 Comments1 Solution90 ViewsLast Modified:
Wanted to get a total count based on a date and criteria.

For example:  On the Count Tab.  I have the days listed  for the month of February and wanted to get a total count of what's on row 3.  The date is on the Open Tab

so 2/1/2019 there is only 8 SUBS and 10 SWG based on whats on column C on the Open Tab, I did the same thing for 2/4/19 as an example.  So wanted to do this for this month and months to come.  See attached file.
C--Users-lfreund-Downloads-COUNT-EE.xlsx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros