How To Use Excel's COUNT Function
The basic COUNT function
The syntax of the
COUNT( value_or_range, value_or_range_2 (optional)...)
Let's take a look at a simple example of
COUNT( 5, 9, 10)
The above formula outputs the number
Here's another, slightly more complicated, example — in which we introduce both errors and strings of text into the mix:
COUNT( 5, "Seven", 10, #N/A, 45)
This formula also outputs
COUNT with a range
The above formula outputs
Practical applications of Excel's COUNT function
- Count the number of student test scores that were recorded in a given period;
- Count the number of days that a stock price was recorded on the market;
- Find the amount of days for which revenue or profitability data is available in a time series; and
- Count up numerical survey results and control for non-responses.
Once you've mastered
Questions or comments on the above? Let us know in the Comments section below!
Save an hour of work a day with these 5 advanced Excel tricks
Work smarter, not harder. Sign up for our 5-day mini-course to receive must-learn lessons on getting Excel to do your work for you.
- How to create beautiful table formatting instantly...
- Why to rethink the way you do VLOOKUPs...
- Plus, we'll reveal why you shouldn't use PivotTables and what to use instead...