LUIS FREUND
asked on
Count based on criteria
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome Luis!
Thanks and same to you too. :)
Thanks and same to you too. :)
ASKER