How to count cells in excel

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.

Add a Comment

Your email address will not be published. Required fields are marked *