Fresh Excel Tips

In this example, we will be using the COUNTIF function to count specific values in a worksheet. We will be using a price list and will try to determine how many products in the price list cost more than $500. The COUNTIF function will count the number of cells in a range that meet this specified criteria. The syntax used for this function is: COUNTIF(range, criteria)
Range: The range of cells.
Criteria: The criteria that specifies which cells to count. This can be a number, expression, or text.

How to Use COUNTIF to Count specified values:

1. In cells A2:A11 enter the different product names.
2. Enter the costs of each product in the adjacent cells B2:B11.
3. In cell C2 enter 500 as the given criteria.
4. Select cell D2 and type the following formula: =COUNTIF(B2:B11,”>” & C1).
5. Press Enter.

With a basic understanding of this formula, you should be able to use this in many other applications.

1. How to Use the PRODUCT function to multiply values in Excel
2. Use the COUNT function to count cells containing numeric data
3. How to Use the COUNTBLANK function to count empty cells
4. How to use SUMIF to add values higher than a certain amount
5. How to Use the COUNTA function to count cells containing data