How to Count Values in a Range in Excel


Excel provides several functions to count the values in a range: COUNT, COUNTA and COUNTBLANK. Each of these functions provides a different solution of counting based on whether the values in your range are numbers, numbers and text, or blank.

The COUNT function counts only numeric values in a given range. The COUNTA function counts any cell that is not blank, and the COUNTBLANK function counts only the blank cells in a given range. All the three functions require single argument: a range of cells.

The figure illustrates how to use these functions:

Count Function


Comments are closed.