How to Count Number of Cells in Excel

Jun 11, 2020 ยท 1 minute read

Here we are going to answer three questions;

  • How to Count cells of the Excel sheet which are not empty.

  • How to Count cells of the Excel sheet which are only contain numbers.

  • How to Count cells of the Excel sheet which only contains the text.

How to Count cells of the Excel sheet which are not empty.

1- Open the Excel sheet.

  1. Click on the empty cell.

  2. Write “=counta(”.

4 - Select the table that you want to count the number of cells.

5- Close the bracket, and press Enter.

countallcell

How to Count cells of the Excel sheet which are only contain numbers.

1- Open the Excel sheet.

  1. Click on the empty cell.

  2. Write “=count(”.

countnum

4- Select the table that you want to count the number of cells.

5- Close the bracket, and press Enter.

countnumber

How to Count cells of the Excel sheet which only contains the text.

1- Open the Excel sheet.

  1. Click on the empty cell.

  2. Write “=counta(”.

4 - Select the table that you want to count the number of cells.

count

5- After you select all the cells write on the cell “)-count(” and again select all the cells.

6- After you select all the cells close the bracket.

count text

7- Press Enter.

table excel

excel cells