Microsoft Excel Functions & Formulas

Use the COUNTIF function to count phases that

cost more than $1000

In this example, some project phases are listed in a worksheet. To

determine how many phases cost more than $1000, use the

COUNTIF function. This function counts the number of cells in a

range that meet the specified criteria.

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.

4

To count specified phases:

1. In cells A2:A11 enter the different phases.

2. Enter the costs of each phase in cells B2:B11.

3. In cell D1 enter 1000 as the given criteria.

4. Select cell D2 and type the following ...