Wednesday, 11 June 2014

COUNTIFS to count on multiple criteria

By , 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.

1 comment:

  1. Private gaming rooms reserved for high-limit avid gamers provide luxurious perks and facilities delivered by attentive casino 아벤카지노 hosts dedicated to your comfort. Regular splits allowed a lot as} three times for a total of four arms. If the vendor has or draws between 17 and 21, all remaining arms must beat the vendor to be able to} be paid.

    ReplyDelete