Countif based on multiple criteria

Question

For reference here's the sheet:

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?

user0 · Accepted Answer · 2019-01-26 19:05:38Z

0

how about using =COUNTIFS() ?

example:

=COUNTIFS(A1:A10, ">20", 
          B1:B10, "<30")

=COUNTIFS(A7:A24, ">6", 
          B7:B24, "<" & DATE(1969,7,20))

=COUNTIFS(B8:B27, ">" & B12, 
          C8:C27, "<" & C13, 
          D8:D27, "<>10")

=COUNTIFS(C1:C100, "Yes")

answered May 18, 2018 at 13:06

user0

27.1k10 gold badges53 silver badges78 bronze badges

Add a comment |

1 Answer 1