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:
Google Spreadsheets now counts the number of numeric cells in the range, and inserts that count into the current cell. |