# COUNTIFS function

Excel COUNTIFS Function is a powerful tool that helps you count the number of cells in a range that meets multiple criteria. It’s like counting items in a store that meet specific conditions, making it handy for various data analysis tasks.

## Syntax

COUNTIFS(range1, criteria1, [range2], [criteria2], …)

## How to use

To use the COUNTIFS function, follow these steps:

1. Select the cell where you want to display the result of your count.
2. Start the formula with `=COUNTIFS(`.
3. Specify the first range and its criteria, like `range1` and `criteria1`.
4. If you have additional criteria, separate them with commas. For example, `range2` and `criteria2`.
5. You can continue adding more ranges and criteria if needed.
6. Close the function with a closing parenthesis `)` and press Enter.

Here are a couple of examples to illustrate how to use COUNTIFS:

This formula counts the number of cells in the range A1:A5 that are greater than 50.

This formula counts the cells where column B is “Red” and column C is “Large” in the respective rows.