## Microsoft Excel 2003 Functions and Formulas

### Count the Number of Cells That Meet a Condition

Summary: Count the number of cells in a range that meet a specified criterion.

You may need to determine how many cells in a given range meet a certain condition. You might want to count how many values in a list are above a certain number. Or, for example, how many of your employees listed in a Human Resources spreadsheet are managers.

Use the Microsoft Excel 2003 function =countif to perform this task.

Take this list of employees, their job titles, and salaries:

`   A     B                 C1  Matt  Customer Service  \$22,0002  John  Sales             \$34,0003  Jane  Executive         \$52,0004  Mary  Manager           \$46,0005  Sue   Sales             \$28,0006  Mark  Customer Service  \$25,000`

Syntax:

=countif(RANGE,CRITERION)

RANGE is the range of cells you want to count.

CRITERION is the condition you want to specify to count.

For example, to count the number of people in Sales:

=countif(B1:B6,"Sales")

This will return 2, the number of employees you have in sales.

Or, if you want to find out how many employees have a salary over \$30,000, use:

=countif(C1:C6, >30000)

This will return 3.

Add: Del.icio.us | Digg | Furl | My Yahoo!