## Introduction

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)

##### Advertisement

### 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.

=COUNT(B2,B3,B4)

*=COUNT(*

*)*you can enter the cells one by one separated by commas. You could also press the Ctrl key and select each cell you wish to count.

To count the cell range B2 to B9, use the formula below:

=COUNT(B2:B9)

### 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:

=COUNT(B2:B5)

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

=COUNTA(B2:B6)

The result is 5. All the entries have been counted!

##### Advertisement

## 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:

=COUNTIF(B2:B6,">3")

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:

=COUNTIFS(B2:B6,">1",B2:B6,"<5")

And the result…

## Conclusion

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.