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
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select STATISTICAL category.
5. Select COUNTIFS function.
6. Then select ok.
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.
