Excel COUNTIFS Function: Multicriteria Data Counting

How To Use COUNTIFS Function

Lets us use simple data and use the formula:

=COUNTIFS(A1:A6,”4″)

The result is 1 as it found simple instance of 4.

But if we have more than one conditions in more than one ranges we will have to use the COUNTIFS instead of the simple countif excel function.

Let have the following data. Lets find someone from team1 with 4 marks:

=COUNTIFS(A2:A7,A4,B2:B7,B2)

Lets see if we have more conditions. I’m adding more data.

Let us see the result of the following formula: =COUNTIFS(A2:A7,A4,B2:B7,B2,C2:C7,”SchoolB”,D2:D7, “2nd”)

Please find below the result: 1 (row 4)

Template

Further reading:
COUNTIF for non-empty cells 
How to countif cells with partial match?  
Basic concepts 
Getting started with Excel
Cell References