How do I use COUNT in Excel?
Use COUNT when you want to count numeric cells. Enter Value 1, Value 2 in that order, then add optional arguments when needed.
Excel Function
COUNT
Counts cells that contain numbers.
COUNT(value1, [value2], ...)Arguments
value1
RequiredSpecify a reference range. You can drag or click start/end cells.
value2
OptionalSpecify a reference range. You can drag or click start/end cells.
Practice Preview
Use COUNT to count numeric cells in Sales in column D. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | AProduct ID | BProduct Name | CCategory | DSales |
|---|---|---|---|---|
| 2 | P001 | Apple | Food | 1200 |
| 3 | P002 | Banana | Food | 980 |
| 4 | P003 | Notebook | Stationery | 450 |
| 5 | P004 | Pen | Stationery | 300 |
| 6 | P005 | Grapes | Food | 1500 |
| 7 | P006 | Ruler | Stationery | 250 |
| 8 | P007 | Peach | Food | 860 |
How to Use (Formula)
=COUNT(D2:D8)Result
7
Practice This Function
COUNT FAQ
Where can I practice COUNT?
Use the "Start Function Practice" button to jump straight into COUNT drills.
What arguments does COUNT use?
The main arguments are Value 1, Value 2. Start with the required ones, then add optional arguments if needed.