We help IT Professionals succeed at work.

Count based on criteria

179 Views
Last Modified: 2019-01-07
Wanted to count values based on certain criteria.   For example per the attachment.

The count is on the "MAT_REC_BY_MONTH" tab and the data is on the "DATA" Tab.  I've added some values on Week 1 and week 2 to show what the values should be.

On "MAT_REC_BY_MONTH" tab:  Column D (REC), the count is based on the "DATA" Tab Column Z filtered on "blanks" on Column AB for Calendar WK 1 on column Y.
On "MAT_REC_BY_MONTH" tab:  Column E (REJ), the count is based on the "DATA" Tab Column Z filtered on "YES" on Column AB for Calendar WK 1 on column Y.

Wanted a formula to count for all the weeks listed on the "MAT_REC_BY_MONTH" tab.  See attachment.
C--Users-lfreund-Downloads-COUNT-EE.xlsx
Comment
Watch Question

Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Awesome!   Thank  you both for the solution!   Happy New Year to both!
Subodh Tiwari (Neeraj)Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Luis!
Thanks and same to you too. :)