Link to home
Start Free TrialLog in
Avatar of Andy N
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((Resolutions!D:D="Complaints")*(Resolutions!J:J="Training and Assessment")))

but I would like to further count by month in the future.

Can you please help?
Avatar of Norie
Norie

Andy

Have you tried COUNTIFS?

For your existing formula.

=COUNTIFS(Resolutions!D:D,"Complaints", Resolutions!J:J, "Training and Assessment")

To include the month either this.

=ARRAYFORMULA(COUNTIFS(Resolutions!D:D,"Complaints", Resolutions!J:J, "Training and Assessment",MONTH(Resolutions!B:B),5))

Or if you added a helper column, e.g. column N with the formula MONTH(B2) copied down

=COUNTIFS(Resolutions!D:D,"Complaints", Resolutions!J:J, "Training and Assessment",Resolutions!N:N,5)
Avatar of Andy N

ASKER

Thanks, Norie! This one worked for what I needed: =ARRAYFORMULA(COUNTIFS(Resolutions!D:D,"Complaints", Resolutions!J:J, "Training and Assessment",MONTH(Resolutions!B:B),5))
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.