How To Count Cells In Excel

Find out how to count cells in Excel with our guide - and several useful methods

How To Count Cells In Excel

Last Updated on

Although you can try manually counting cells in Excel, this strenuous task is likely to lead to a wrong count and missed cells. Instead, Excel provides an easier way to sort, order, and count cells, so you can better understand your data.

How to Count Cells In Excel

1

How To Count Non-Empty Cells In Excel

In this section, we’ll cover using the COUNTA function to count the number of cells in an Excel spreadsheet that are non-void, and contain values.

To count non-empty cells in Excel:

Step

1

Select The Cell

Select the cell in which you want the results of the count to appear.

Step

2

Go To Formulas Tab

On the Menu Bar, select the Formulas Tab. Under Function Library, select More Functions, and then click on Statistical.

Step

3

COUNTA Function

Select The COUNTA function.

In the Function Arguments dialog box, provide the range of cells on which the count function is to be applied.

Select OK.

Step

4

Alternatively

  • Select the cell in which you want the results of the count to appear.
  • In the Formula Bar, type the COUNTA function. This is the syntax =COUNTA(VALUE1:VALUE2).
  • VALUE1:VALUE2 sets the range of cells.
  • Press Enter.

How to count non-empty cells in Excel

2

How To Count Empty Cells In Excel

In this section, we’ll cover using the COUNTBLANK function to count the number of cells in an Excel spreadsheet that contain no value, and are considered void.

To count empty cells in Excel:

Step

1

Select The Cell

Select the cell in which you want the results of the count to appear.

Step

2

Go To Formulas Tab

On the Menu Bar, select the Formulas Tab. Under Function Library, select More Functions, and then click on Statistical.

Step

3

COUNTBLANK Function

Select the COUNTBLANK function.

In the Function Arguments dialog box, provide the range of cells on which the count function is to be applied.
Select OK.

Step

4

Alternatively

  • Select the cell in which you want the results of the count to appear.
  • In the Formula Bar, type the COUNTBLANK function. This is the syntax =COUNTBLANK(VALUE1:VALUE2). VALUE1:VALUE2 sets the range of cells.
  • Press Enter.

COUNTBLANK

3

How To Count Cells Containing Numbers In Excel

In this section, we’ll cover using the COUNT function to count the number of cells in an Excel spreadsheet that contain a numerical value.

To count cells containing numbers in Excel:

Step

1

Select The Cell

Select the cell in which you want the results of the count to appear.

Step

2

Go To Formulas Tab

On the Menu Bar, select the Formulas Tab. Under Function Library, select More Functions, and then click on Statistical.

Step

3

Select The COUNT Function

Select the COUNT function.

In the Function Arguments dialog box, provide the range of cells on which the count function is to be applied.

Select OK.

Step

4

Alternatively

Select the COUNT function.
In the Function Arguments dialog box, provide the range of cells on which the count function is to be applied.
Select OK.

How to count cells containing numbers in Excel

4

How To Count Cells With Specific Criteria In Excel

In this section, we’ll cover using the COUNTIF function to count the number of cells in an Excel spreadsheet that contain specific criteria, such as text.

To count cells containing specific criteria in Excel:

Step

1

Select The Cell

Select the cell in which you want the results of the count to appear.

Step

2

Formulas Tab

On the Menu Bar, select the Formulas Tab. Under Function Library, select More Functions, and then click on Statistical.

Step

3

COUNTIF Function

Select the COUNTIF function.

In the Function Arguments dialog box, provide the range of cells on which the count function is to be applied, and the criteria to look for.

Select OK.

Step

4

Alternative

Select the cell in which you want the results of the count to appear.

In the Formula Bar, type the COUNTIF function. This is the syntax =COUNTIF(VALUE1:VALUE2, “CRITERIA”). VALUE1:VALUE2 sets the range of cells.

Press Enter.

How to count cells with specific criteria in Excel

Conclusion

The COUNTA, COUNTBLANK, COUNT, and COUNTIF formulas can be used to quickly and correctly calculate the number of cells in an Excel spreadsheet. Using these will provide accurate counts, and avoid the stress and strain of manually counting – something nobody should ever have to do!

You might like this

Adding a trendline to a chart can make it easier for readers to interpret the data.
Are you trying to make your Microsoft Excel sheet easier to read for others?
Are you trying to make your spreadsheet more readable for Excel’s formulas? Here's how
Avoid typing errors by using the autofill setting to add dates to Excel

Share this article

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Managing Editor
at
PC guide
Kevin has been a technophile since he first owned a Commodore 64. Then an Amiga….progressing to Gameboy, self-built systems, consoles, and a 15-year career in and around computing and technology. Kevin is an all-around tech and gadget enthusiast. He was previously found at such places as Micro Mart, Custom PC, Bit-tech, and PC PRO, then Which? Computing, Den of Geek, and Daily Telegraph. Also WIRED, Hardware Heaven, and KitGuru.

Independent, transparent, rigorous and authentic, our reviews are the most thorough and honest in PC gaming. Learn about our review process.

Leave a Comment