http://www.freefilehosting.net/drinktea
Count Cells with Numbers -- Excel COUNT
The 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 COUNT formula.
The following COUNT function example uses one argument -- a reference to cells A1:A5.
Enter the sample data on your worksheet
In cell A7, enter an COUNT formula, to count the numbers in column A: =COUNT(A1:A5)
Press the Enter key, to complete the formula.
The result will be 3, the number of cells that contain numbers.
Cell A1 isn't counted, because it contains tex
Count Cells with Numbers -- Excel COUNT
The 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 COUNT formula.
The following COUNT function example uses one argument -- a reference to cells A1:A5.
Enter the sample data on your worksheet
In cell A7, enter an COUNT formula, to count the numbers in column A: =COUNT(A1:A5)
Press the Enter key, to complete the formula.
The result will be 3, the number of cells that contain numbers.
Cell A1 isn't counted, because it contains tex
No comments:
Post a Comment