Using the COUNT Function

The SUM function isn't the only function listed separately on the Formulas tab. Also listed are the COUNT, AVERAGE, MIN, MAX, and PRODUCT functions. We'll discuss each in turn; let's start with COUNT.

The COUNT function does just as its name implies; it counts the number of cells in a range that contain numeric values. To use the COUNT function, follow these steps:

1.	Select the cell where you want the count to appear.
2.	Click the Count link; this inserts =Count( into the selected cell.
3.	Use your keyboard or mouse to select the range of cells you want counted.
4.	Use your keyboard to enter the ) character to close the function argument.
5.	Press the Enter key.

Google Spreadsheets now counts the number of numeric cells in the range, and inserts that count into the current cell.