1. Computing

Google Spreadsheet COUNT Function

Using the Google Spreadsheets COUNT Function

By

Google Spreadsheets COUNT Function

Google Spreadsheets COUNT Function

© Ted French

The COUNT function, in Google Spreadsheets is used to count up the cells in a selected range that contain numbers - the function ignores blank cells, text and other types of data..

The syntax for the COUNT function is:

= COUNT ( value_1 , value_2 , ... value_30 )

value - the numbers or values to be totaled. This can also be a range of cell references where the data is located.

If cell references are used, the COUNT function ignores empty cells or text data in cells in the selected range.

If number data is later added to an empty cell in the range, the count total is automatically updated.

Example Using the Google Spreadsheet COUNT Function:

  1. Enter the following data into cells A1 to A5: 114, 165, 178, 143, 130.

  2. In cell A6 type the word test

  3. Leave cell A7 blank.

  4. Click on cell A8 - the location for the function and where the results will be displayed.

  5. Click on Insert > Formula > COUNT in the menus.

  6. Google Spreadsheets inserts the first part of the function = COUNT ( into cell A8.

  7. Drag select cells A1 to A7 with the mouse pointer to enter that range into the function.

  8. Type the closing bracket " ) " after the cell range in cell A8.

  9. Press the ENTER key on the keyboard.

  10. The answer 5 appears in cell A8 because only five cells in the range A1 to A7 contain numbers. Cells A6 and A7 are ignored.

  11. Type the number 180, in cell A7 and press the ENTER key on the keyboard.

  12. The function total in cell A8 should change from 5 to 6 since now six cells in the range contain numbers.

  13. When you click on cell A7 the complete function = COUNT ( A1 : A7 ) appears in the formula bar above the worksheet. .

©2014 About.com. All rights reserved.