You have a spreadsheet with a huge database and need to know how many cells in a given area or in the whole workbook contain only numbers, not letters. Instead of having to sit around manually, you can use the = COUNT function. For example, you need to count cells B2 through B16, type = COUNT (B2: B16).
- Step 1: click on any cell
- Step 2: type = count(
- Step 3: Select all cells to count
- Step 4: Type enter
The result is the number of cells to count.