COUNT formula in Excel with examples

The COUNT function in Excel allows you to count the number of cells that contain numbers within a specified range. Here’s how it works:

1. Syntax:

   =COUNT(range)
   

   • range: The range of cells you want to count.

2. Example: Suppose you have data in cells A2 through A7:

   12/8/08
   19
   22.24
   TRUE
   #DIV/0!
   

   • To count the number of cells containing numbers in this range, use:

     =COUNT(A2:A7)
     

     Result: 3 (since three cells contain numbers).

Remember that text values and blank cells are ignored when using COUNT!