Count Cells with Numbers -- Excel COUNT

[Way To Excel]

Dear Friends

Find the below function and its description for counting the number of cells only it has numeric values in a range.

The Excel COUNT function will count cells that contain numbers. Its syntax is:
    =COUNT(value1, value2,...value30).
The arguments (e.g. value1) can be cell references, or values typed into the Excel COUNT formula.

The following Excel COUNT function example uses one argument -- a reference to cells A1:A5.

1. Enter the sample data on your worksheet
2. In cell A7, enter an Excel COUNT formula, to count the numbers in column A:   =COUNT(A1:A5)  
3. Press the Enter key, to complete the formula.
4. The result will be 3, the number of cells that contain numbers.
   Cell A1 isn't counted, because it contains text.

Note: Since dates are stored as numbers, the Excel COUNT function will include any cells that contain dates. 

--
Way to Excel