Count based on a date

LUIS FREUND
LUIS FREUND used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Please try this...
In E4
=COUNTIFS(OPEN!$N:$N,$D4,OPEN!$C:$C,E$3)

Open in new window

and then copy it across and down.

Author

Commented:
PERFECT!!!!   Thank you very much Neeraj!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Luis!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial