The Countif function counts the number of items that meet a certain criteria. This criteria can be a number range or a word. This is useful when determining the number of entries within a certain range, such as test scores or the number of entries that equal a certain value, like the class rank of "junior" or "senior."

Windows: From the Or select a category pull-down list, select All or StatisticalMacintosh: From the Function category scroll box, select All or Statistical

Windows: From the Select a function scroll box, select COUNTIFMacintosh: From the Function name scroll box, select COUNTIF

Click OKThe Function Arguments dialog box appears.

In the Range text box, type the range of cellsOR

Click COLLAPSE DIALOGor

Within your worksheet, select the range of cells to analyzeNOTE: These are the cells which will be analyzed to see if they meet the criteria you select.

Click RESTORE DIALOGor

In the Criteria text box, type the appropriate criteria, such as the numerical range, text value, or expression (e.g., >2) EXAMPLE: To count the number of students with a class rank of "senior," type senior

Click OKThe appropriate number appears in the cell you selected and the formula appears in the FormulaBar.EXAMPLE: The formula should look something like =COUNTIF(C2:C11,"senior") with C2:C11 being the range, and "senior" the criteria.

Windows: From the Or select a category pull-down list, select All or Math & Trig Macintosh: From the Function category scroll box, select All or Math & Trig

Windows: From the Select a function scroll box, select SUMIFMacintosh: From the Function name scroll box, select SUMIF

Click OKThe Function Arguments dialog box appears.

In the Range text box, type the range of cellsOR

Click COLLAPSE DIALOGor

Within your worksheet, select the range of cells to analyzeNOTE: These are the cells which will be analyzed to see if they meet the criteria you select.

Click RESTORE DIALOGor

In the Criteria text box, type the appropriate criteria (such as the numerical range or text value)EXAMPLE: If you would like to add the test scores of the students with a class rank of "senior," type seniorOR

Click COLLAPSE DIALOGor

Within your worksheet, select the appropriate criteria

Click RESTORE DIALOGor

In the Sum_range text box, type the range of cellsEXAMPLE: If you would like to add the text scores of seniors, select the cell range that contains the test scores OR

Click COLLAPSE DIALOGor

Within your worksheet, select the range of cells to analyzeNOTE: These are the cells which will be summed of the criteria has been met.

Click RESTORE DIALOGor

Click OKThe sum appears in the selected cell and the formula appears in the FormulaBar.EXAMPLE: The formula should look something like =SUMIF(C2:C11,"senior") with C2:C11 being the range and "senior" being the criteria.