COUNTIF with multiple criteria

Question

Can you please advise on how can I use COUNTIF with multiple conditions?

enter image description here

My proposal (left) shows the formula for one criterion (distinct regions).

However, I am interested in counting distinct regions for each distinct month (two criteria) - on the right: desired result.

score 12 · Answer 1 · edited Oct 17 '21 at 20:21

12

you can use COUNTIFS() instead

=1/COUNTIFS($A:$A,A2,$B:$B,B2)

edited Oct 17 '21 at 20:21

pevik

answered Jun 20 '13 at 14:18

JosieP

1 Answers1