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.
No comments:
Post a Comment