In this post, we will learn about Excel COUNT Function with examples.
Excel COUNT Function – Definition
Excel COUNT function is a built-in function of Microsoft Excel and its feature are as follows:-
This function counts only numeric values in a cell or a range of cells. And skips the text values in the same range.
As we know that many types of data within a range but only numeric values will count.
Excel COUNT function works with integers, decimal values, DATE values. It will not count any blank cell and text in the range.
It Returns a Value
Excel COUNT Function will return, counts the number of cell in a range has numeric values.
=COUNT (value1, [value2],….[value 255])
value1: this is the item, cell reference or a range within which we want to count numbers.
[value2]: (optional) up to [value 255] more items, cell reference or a range within which we want to count numbers.
Things to Remember
Numeric values will count and empty cells or text will not count.
Logical values and text representations of numbers that we type into the list of arguments count.
Any arguments that are error values or text that cannot translate into numbers will not consider.
If an argument is an array or reference, only numbers in that array or reference will count. Empty cells, logical values, text, or error values in the array or reference will not count.
If any cell has TRUE and FALSE in the range. Excel COUNT Function will consider it as text and skip these values.
Here in this example, we can see that there are many types of data store in this table. And in the cell A9, we apply the COUNT function to make a count of all the values.
When we apply the formula =COUNT (A2: A8) and press Enter, our result is only 4.
Which means the COUNT formula is skipping the values which are not a numeric value. Excel COUNT function is skipping all text values in the range.
In the second example, we have two column with data and data table has both text and numeric values.
Now at the bottom of the table, we apply COUNT function two different ways.
We want to show that we can apply COUNT function in different ways. Either consider the whole table as a single range by applying formula as (=COUNT (C2: D7).
And second way, we can set the formula one by one column:- =COUNT(C2: C7, D2: D7) and so on. There will be no difference in the resulting figure.