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)
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)
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)
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

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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

network discovery keeps turning off server 2016

How to Fix Network Discovery If it Keeps Turning Off in Server 2016

Does network discovery keep turning off in your Windows server 2016? It is likely that one of its dependent services is not...
how to install windows 10 1903 update manually

How to Install Windows 10 1903 Update Manually

Windows 10 1903 Update was released in May, 2019. But some users are not yet offered the update via automatic update. The...
spotify web player not working

Spotify Web Player Not Working [Fixed]

Introduction Spotify Web Player may stop working for you with the following error messages: "Spotify Web Player an Error...
DISM.exe /Online /Cleanup-Image /Restorehealth

DISM.exe /Online /Cleanup-Image /Restorehealth Explained

What is DISM.EXE /Online /Cleanup-image /RestoreHealth? "DISM.exe /Online /Cleanup-Image /Restorehealth" is a DISM command that repairs issue with the...
DHCP Relay agent

DHCP Relay Agent: Configuration in Windows Server 2016

What is a DHCP Relay Agent? A DHCP Relay Agent allows DHCP clients in a different network subnet to...

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

BEST OF ITECHGUIDES

Reset Windows 10

How to Reset Windows 10 (2 Methods)

Introduction If your Windows 10 is broken, one available way to fix it is to use Windows 10 reset....
Active Directory FSMO Roles

Active Directory FSMO Roles Explained

Introduction This article offers a simplified explanation of the 5 Active Directory FSMO (pronounced "FisMO") roles.
How-to-Calculate-Standard-Deviation-in-Excel

How to Calculate Standard Deviation in Excel

Introduction Standard Deviation is a measure of how dispersed values are from their mean (average). You can calculate standard...
RAID 3 (Redundant Array of Independent Disks) Explained

RAID 3 (Redundant Array of Independent Disks) Explained

What is RAID 3? RAID 3 is a RAID implementation that uses striping with a dedicated parity disk....
How to Calculate Variance in Excel

How to Calculate Variance in Excel

Introduction Variance measures the spread between numbers in a data set. You can calculate variance in Excel using the...

RECENT POSTS

disable cortana windows 10 featured

How to Disable Cortana in Windows 10 (2 Methods)

Introduction Some Windows 10 users may not like Cortana. Solution? Disable Cortana. You are probably reading this because you...
bootrec /fixboot access is denied

How to Fix BootRec /FixBoot Access is Denied Error in Windows 10

Introduction BootRec /FixBoot Access is Denied Error in Windows 10? This error is likely caused by corrupt EFI directory.
Reset Windows 10

How to Reset Windows 10 (2 Methods)

Introduction If your Windows 10 is broken, one available way to fix it is to use Windows 10 reset....
system restore windows 10

How to Enable and Use System Restore in Windows 10

Introduction System restore in windows 10 is a very important tool that is probably ignored by most users. But...
windows has stopped this device code 43

How to Fix Windows Has Stopped this Device Code 43 Error

Introduction Sometimes you may receive "Windows has stopped this device code 43" error. This error is likely to come...
Windows could not automatically detect this network's proxy settings

How to Fix “Windows Could not Automatically Detect this Network’s Proxy Settings”

Introduction You suddenly lose the ability to connect to the internet. Then you run network troubleshooter and it returns...
printer offline

5 Ways to Restore Your Printer Online If Status is Offline

Introduction Is your printer offline? Setting it online is very simple but sometimes it is more than just setting...

How to Fix “BootMgr is Missing” Error in Windows 10

Introduction If you receive Fix "BootMgr is missing" Error in Windows 10, the default response is panic! But you...
windows 10 search featured

How to Fix Windows 10 Search If it Stops Working

Introduction Are you having troubles with Windows 10 search? Apparently, it is a fairly common problem with a number...
oooops, something went wrong. reload

How to Fix “Oooops something went wrong. reload” Spotify Error

Introduction If you receive "Oooops something went wrong. reload" Spotify error, do not panic. The fix is simpler than...

MUST READ

Check Disk (CHKDSK) Windows 10

Check Disk (CHKDSK) in Windows 10: Syntax, Parameters, Examples

Introduction Check Disk (CHKDSK) is a Windows 10 command tool that checks a disk for errors, fixes errors, recovers...

Powershell For Loop Explained: Syntax and Examples

Introduction "Powershell For Loop" (or Statement) is a construct that is used to run a command in a...
powershell help

Get-Help Command: Syntax, Parameters, Examples

Introduction Don't know how to use a PowerShell cmdlet? PowerShell Get-Help cmdlet will give you information about any powerShell...
powershell sleep

PowerShell Start-Sleep Command: Syntax, Examples

Introduction Powershell Sleep (Start-Sleep) Cmdlet is a very useful scripting tool. There may be instances when you want to...
Windows defender blocked by Group Policy

Windows Defender Blocked by Group Policy [Fixed]

Introduction If you receive the error message Windows Defender is blocked by group policy, your computer may have been...

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