# Countif Multiple Criteria

This article outlines how to use the Countifs function in Excel to count cells where multiple criteria are met.

### How to countif multiple criteria?

​The Excel formula to countif with multiple criteria is =countifs(). The “s” on the end makes it plural and therefore implies that there are multiple criteria (2 or more).

​In the examples and illustrations below this tutorial will show you exactly how to use countifs in Excel.

### How to use countifs

Coutifs works just like countif, except you can added additional criteria separated by commas. Here is step-by-step instruction on how to do it.

Step 1: document the criteria or conditions you wish to test for
Step 2: type “=countifs(“ and select the range you want to test the first criteria on
Step 3: input the test for the criteria
Step 4: select the second range you want to test (it can be the range again, or a new one)
Step 5: input the test for the criteria
Step 6: repeat above as many times as necessary
Step 7: close “)” and press enter

### Example of countif with multiple criteria

This screenshot shows counting with multiple conditions in action. As you will see, each of the criteria are being tested and Excel is counting the number of times the result from the test is true.