(5) How to use Count formula in Microsoft Excel.
Count: The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
=COUNT(RANGE)
Example:
Give the formula in B11 cell.
| Formula |
Description |
Result |
| =COUNT(B2:B10) |
here RANGE=B2:B10, you can use any range as per your requirement |
9
|
=COUNT((B2,B3,B4,B5,B6,
B7,B8,B9,B10) |
|
9
|
Video:
How to use Count formula in Microsoft Excel:
|