How to Use COUNTIFS Function

In this Excel tutorial article, we will try to learn all the possible ways to use the COUNTIFS functions. 

Countifs function basics

Let us start with a simple COUNTIFS function. Let us use simple data and use the formula: =COUNTIFS(A1:A6,"4")


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

COUNTIFS formula result

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

Let's have the following data. Find someone from team1 with 4 marks: =COUNTIFS(A2:A7,A4,B2:B7,B2)

COUNTIFS formula

See if we have more conditions. I'm adding more data.

COUNTIFS formula school 2nd

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

COUNTIFS formula school 2nd result

Please find below the result: 1 (row 4).

COUNTIFS results

Further reading: 
COUNTIF for non-empty cells 
How to countif cells with partial match?