Andy N
asked on
Google Spreadsheet Counting Based on Multiple Criteria
For reference here's the sheet:
https://docs.google.com/spreadsheets/d/1CS-fYhqeKRmEiJC5XA6kRIwIjyBDlBcXj-K9FHjCZjA/edit?usp=sharing
I am trying to create a filter that shows me all the data for May based on type and course category. I highlighted these in blue in the sheet.
I worked out how to count the type and category using this formula:
=arrayformula(SUM((Resolut ions!D:D=" Complaints ")*(Resolu tions!J:J= "Training and Assessment")))
but I would like to further count by month in the future.
Can you please help?
https://docs.google.com/spreadsheets/d/1CS-fYhqeKRmEiJC5XA6kRIwIjyBDlBcXj-K9FHjCZjA/edit?usp=sharing
I am trying to create a filter that shows me all the data for May based on type and course category. I highlighted these in blue in the sheet.
I worked out how to count the type and category using this formula:
=arrayformula(SUM((Resolut
but I would like to further count by month in the future.
Can you please help?
ASKER
Thanks, Norie! This one worked for what I needed: =ARRAYFORMULA(COUNTIFS(Res olutions!D :D,"Compla ints", Resolutions!J:J, "Training and Assessment",MONTH(Resoluti ons!B:B),5 ))
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Have you tried COUNTIFS?
For your existing formula.
=COUNTIFS(Resolutions!D:D,
To include the month either this.
=ARRAYFORMULA(COUNTIFS(Res
Or if you added a helper column, e.g. column N with the formula MONTH(B2) copied down
=COUNTIFS(Resolutions!D:D,