Link to home
Create AccountLog in
Avatar of LUIS FREUND
LUIS FREUND

asked on

Count based on a date

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
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of LUIS FREUND
LUIS FREUND

ASKER

PERFECT!!!!   Thank you very much Neeraj!
You're welcome Luis!