Excel COUNT Function is used for counting items in a worksheet. Excel COUNT also has the conditional function, COUNTIF. COUNTIF counts if a specific condition is TRUE.
This guides shows how to use Excel COUNT and COUNTIF functions.
How to Count in Excel Using Excel Count Function
Excel Count function can count individual cells or a cell range.
Here is the syntax to COUNT individual cells:
COUNT (cell 1, cell 2, cell3)
To COUNT a cell range:
COUNT (cell 1:cell 3)
Excel Count Example 1 (COUNT Function)
In this section I will demonstrate how to count individual cells and a cell range.
To count cells B2,B3 and B4, use the formula below.
To count the cell range B2 to B9, use the formula below:
Excel Count Example 2 (COUNTA Function)
The worksheet below (cells B2 to B6) shows a number and a number enclosed in quotation marks. The worksheet also has date, error and text values.
If you use the COUNT function to count B2 to B6:
The result will be 2. The reason is because COUNT function cannot count numbers enclosed in quotation marks. Also, it cannot count texts or errors. However, you can use COUNT to count numbers and dates.
To count logical values, text, or error values, use the COUNTA function. The formula below will count all values in cells B2 to B6
The result is 5. All the entries have been counted!
How to Count in Excel Using Excel CountIF Function
CountIF Function counts cells that meet a specific condition.
Below is the Syntax
COUNTIF (range, criteria)
range – the cell range you want to count
criteria – the condition that must be met for a cell to be counted
Excel COUNTIF Example
Refer to the worksheet in the image above. To count only numbers greater than 3, use the formula:
The result is 2.
If you want to add multiple conditions, use COUNTIFS.
In the Excel Count example below, I will use COUNTIFS to count how many numbers (excluding 1 and 5) that are contained in cells B2 to B6.
Here is the formula:
And the result…
The COUNT Function comes in handy when you need to Excel to count a set of cells or a range. One thing to be in mind though: if you need to count logical values, text, or error values, use the COUNTA function.
If you have any question use the “Leave a Reply” form at the end of this page. You could also share your experience so that other readers can benefit.