Excel Count: How to Count in Excel With Examples

-

|

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)

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)
How to Count in Excel Using Excel Count Function
When you type =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)
On the COUNT formula you can enter the cell range manually separated by a colon, (:). You could also press the Shift key and select the cells you wish to add to the range.

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.

Excel Count Example 2 (COUNTA Function)

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!

Excel Count Example 2 (COUNTA Function)

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

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.

Other Helpful Guides

Additional Resources and References

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

ADVERTISEMENTS

FEATURED POSTS

Best Christian Movies on Netflix

The 10 Best Christian Movies on Netflix

This Itechguide reviews the 10 best christian movies on Netflix. The movies are listed in reverse order – with the 10th movie...
How to Change Orientation in Google Docs

How to Change Orientation in Google Docs

This Itechguide teaches you how to change orientation in Google Docs. The guide covers steps to change orientation in Google Docs from...
How to Delete Google Photos

How to Delete Google Photos

This Itechguide teaches you how to delete Google Photos. The guide offers steps to delete Google Photos from the Google Photos App...
How to Install Windows 10 1909 Update Manually

How to Install Windows 10 1909 Update Manually

This Itechguide teaches you how to install Windows 10 1909 update manually. Windows 10 1909 (otherwise known as Windows 10 November update)...
How to Create a Poll on Facebook

How to Create a Poll on Facebook

This Itechguide teaches you how to create a poll on Facebook. You can create a poll on Facebook from a Facebook page...

AMAZON DEALS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

ADVERTISEMENTS

BEST OF ITECHGUIDES

How to Change Instagram Name

How to Change Instagram Name

This Itechguide teaches you how to change Instagram name. The guide offers steps to change Instagram name from a PC/Mac or from...
Error Code 0xc004fc07 in Server 2016 - "We Can't activate Windows on the device right now."

How to Fix “We Can’t Activate Windows on this Device right Now”

Introduction When you try to activate Windows Server 2016 with the GUI tool you may receive error code 0xc004fc07...

Our 10 Best French Movies on Netflix

Craving to know the best French movies available on Netflix? You are in the right place. We have a...
Best fantasy Movies on Netflix

Our 10 Best Fantasy Movies on Netflix

Are you ready to know the best fantasy movies on Netflix? Then dive into the fantasy world with us filled amazing...
PowerShell Not Equal

PowerShell Not Equal Operator: Applications, Examples

Introduction PowerShell Not Equal Operator is one of the Comparison Operators. PowerShell Not Equal (-ne) compares two values. If...

RECENT POSTS

How to Change Facebook Page Name

How to Change Facebook Page Name

This Itechguide teaches you how to change Facebook page name. The guide covers steps to change Facebook page name from a PC...
How to Change YouTube Channel Name

How to Change YouTube Channel Name

This Itechguide teaches you how to change YouTube channel name. The guide covers steps to change YouTube channel name from a PC.
How to Bold Text on Facebook Post

How to Bold Text on Facebook Post

This Itechguide teaches you how to bold text on Facebook post. The guide covers steps to bold text on Facebook post from...
Best Crime Documentaries on Netflix

The 10 Best Crime Documentaries on Netflix

This Itechguide reviews the 10 best crime documentaries on Netflix. The documentaries are listed in reverse order – with the 10th documentary...
Best Netflix Series

The 10 Best Netflix Series

This Itechguide reviews the 10 best Netflix series. The series are listed in reverse order – with the 10th series on top....

AMAZON DEALS

MUST READ

RAID 4 Featured image

RAID 4 (Redundant Array of Independent Disks) Explained

What is RAID 4? RAID 4 is a RAID configuration that uses block-level striping across multiple disks with a...
How to Remove Google Profile Picture

How to Remove Google Profile Picture

This Itechguide teaches you How to remove Google profile picture. The guide covers steps to remove your profile picture from a PC,...
we can t sign into your account

How to Fix “We Can’t Sign into Your Account” Error in Windows 10

Introduction You may receive "we can't sign into your account" error after upgrading to Windows 10. If this occurs...
WSUS Server 2016 Requirements

WSUS Server 2016 Requirements

Introduction This guide lists all WSUS Server 2016 Requirements. The following requirements are included: Hardware...
Spotify Playlists

How to Find, Download or Share Spotify Playlists

Introduction This quick guide will show you step by step how to find, download or share Spotify Playlists. You...

AMAZON DEALS

By using this website you agree to accept our Privacy Policy and Terms & Conditions