COUNTIFS to count on multiple criteria

By Neil Shorney, Director, Naturally Sales Ltd.

In this e-tip, we'll introduce you to the COUNTIFS function, which allows multiple criteria.

It works like this:

=COUNTIFS(range_1, criteria_1, range_2, criteria_2, etc...)
...where "range" is the range you'd like to analyse, and "criteria" is what you're looking for. For example, if A1:A5 had the following values:

USA, UK, Germany, USA, France

and B1:B5 had the following:

English, English, German, Spanish, French

...you could then enter this formula into C1:

=COUNTIFS(A:A,"USA",B:B,"English"), which would return a value of "1" because only in row 1 do both criteria match.