Microsoft Excel
--
Questions
--
Followers
Top Experts
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
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
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. :)
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.