Excel COUNTIFS Function

What is COUNTIFS function in Excel?


The COUNTIFS function is one of the Statistical functions of Excel.

It counts the number of cells specified by a given set of conditions or criteria.

We can find this function in Statistical category of insert function Tab.

How to use COUNTIFS function in excel

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select COUNTIFS function.

6. Then select ok.

excel COUNTIFS function

7. In the function arguments Tab you will see COUNTIFS function.

8. Criteria_range1: is the range of cells you want evaluated for the particular condition.

9. Criteria1 is the condition in the form of a number, expression, or text that defines which cells will be counted.

10. Criteria_range2: is the range of cells you want evaluated for the particular condition.

11. Criteria2 is the condition in the form of a number, expression, or text that defines which cells will be counted.

12. You will see the results in the formula result section.

Examples of COUNTIFS function in Excel

COUNTIFS related functions 

  • Use COUNT function to count the number of cells in a range that contains numbers.
  • Use COUNTBLANK function to count the number of empty cells in a specified range of cells.
  • Use COUNTA function to count the number of cells in a range that are not empty.
  • Use COUNTIF function to count the number of cells within a range that meet the given condition.

Leave a Reply

Your email address will not be published. Required fields are marked *