 # COUNTIF Function in Microsoft Excel 2013

## COUNTIF Function in Microsoft Excel 2013

The COUNTIF function combines the COUNT function and the IF function.  Use it when you want to count any cells that match a certain condition. In the example, we want Excel to count how many people have worked enough hours to qualify for overtime. So we set up a COUNTIF Function to count how many times the word “Overtime” occurs in the Overtime column. Figure – Result returned

### The structure of a COUNTIF Function

=COUNTIF(C6:C9,”yes“)

This says, look in the cells C6 to C9, and if you find the work yes in them count how many times.

The structure of a COUNTIF always contains the same four elements.

• Starts with =COUNTIF(
• The range of cells that Excel is to look at
• The criteria which Excel will use to count
• Close brackets

To make this COUNTIF function easier to understand in this example, the rangeis in purpletext and the criteria is orangetext.

### Typing in a COUNTIF Function Figure – Type the Countif function directly into the cell

1. Click in the cell where you want the answer
2. Type =COUNTIF(
3. Highlight the range of cells you are counting from
5. Press Enter

Happy Learning! This topic has been taken from my free eBook on Microsoft Excel Core: Advanced 2013 which can be downloaded here: 