The COUNT function is used to count cells that contain numbers.
Syntax:
=COUNT(value1, [value2],..)
Arguments:
value1: These can be cell references or can be directly entered. A continuous range of cells can be given as single argument.
Follow the below steps to count cells with numbers:
1. Enter the data in the worksheet
2. Select any cell where you want to get the count of cells
3. Enter an COUNT formula and select the required cell range as argument
4. Press the Enter key.
This will give the count of the cells that contain numbers
Note: Since excel stores dates in number format, the same will also be counted using COUNT function
Syntax:
=COUNT(value1, [value2],..)
Arguments:
value1: These can be cell references or can be directly entered. A continuous range of cells can be given as single argument.
Follow the below steps to count cells with numbers:
1. Enter the data in the worksheet
2. Select any cell where you want to get the count of cells
3. Enter an COUNT formula and select the required cell range as argument
4. Press the Enter key.
This will give the count of the cells that contain numbers
Note: Since excel stores dates in number format, the same will also be counted using COUNT function
No comments:
Post a Comment