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
Microsoft OfficeMicrosoft ExcelMicrosoft ApplicationsSpreadsheets
Last Comment
Subodh Tiwari (Neeraj)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Awesome! Thank you both for the solution! Happy New Year to both!
You're welcome Luis!
Thanks and same to you too. :)
Thanks and same to you too. :)