This video explains how to use the COUNT function in Microsoft Excel. It covers the function's parameters, its best use cases, and details what types of data it counts and what it ignores.
Key takeaways
The COUNT function in Excel is used to count the number of cells in a specified range that contain numbers.
It has one primary parameter: the data range to evaluate. Multiple ranges or individual values can be included, separated by commas.
COUNT only tallies cells containing actual numbers, including dates and decimal numbers.
It does not count blank cells, text, or error messages. Even if cells are formatted as text, if they contain numbers, they will be counted.
The function can accept up to 255 arguments, allowing for a combination of ranges and individual values.