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

How to Share a Folder in Windows 10 (3 Methods)

Introduction This guide demos how to share folder in windows 10. It covers 3 methods. Options...

How to Map Network Drive in Windows 10 (5 Methods)

Introduction This guide demos 5 methods to Map Network Drive in Windows 10. Options to...
How to Install Windows 10 1909 Preview Build

How to Install Windows 10 19H2 Preview Build

Introduction If you are a member of Windows 10 Insider Program you can install Windows 10 19H2 Preview Build....

How to Sign in to Windows 10 with a Microsoft Account

Introduction When you installed Windows 10 you may have created and signed in with a local account. You can...
Disable IPv6 in Windows 10

How to Disable IPv6 in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to disable IPv6 in Windows 10: Disable IPv6 from...

Advertisement

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

Advertisement

BEST OF ITECHGUIDES

active directory interview questions

35 Active Directory Interview Questions and Answers

I have compiled 35 Active Directory interview questions and answers. Where necessary, I have also provided additional information to help you understand...
0xc000021a: Status System Process Terminated Error [Fixed]

0xc000021a: Status System Process Terminated Error [Fixed]

Introduction You may receive "0xc000021a (STATUS_SYSTEM_PROCESS_TERMINATED)" error after installing a new device on your Windows computer. You may also...
how to make Pivot Table

How to Make a Pivot Table in Excel

Introduction A Pivot Table allows you to analyze, summarize and calculate large data to help find relationships. With a...

How to Fix “Your PC Ran into a Problem and Needs to Restart” in...

Introduction "Your PC Ran into a Problem and Needs to Restart" in Windows Server 2016 error may be caused...
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...

RECENT POSTS

How to Enable Hyper-V in Windows 10 (3 Methods)

How to Enable Hyper-V in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to enable Hyper-V in Windows 10. To install Hyper-V...
RSAT Tools in Windows 10 Explained: Plus How to Install RSAT

RSAT Tools in Windows 10 Explained: Plus How to Install RSAT

Introduction Starting from October 2018 (1809) update, RSAT Tools became part of Windows 10. From this version of Windows...

How to Enable RSAT for Active Directory in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to enable Active Directory in Windows 10. It is not exactly enabling "Active...
How to Install Windows 10 1909 Preview Build

How to Install Windows 10 1909 (19H2) Preview Build

Introduction Windows 10 1909 Preview is available for Windows Insiders. Made available early September, 2019 you have to be...
How to Install RSAT in Windows 10 (3 Methods)

How to Install RSAT in Windows 10 (3 Methods)

Introduction This guide demos how to Install RSAT in Windows 10. Starting with Windows 10...

How to Share a Folder in Windows 10 (3 Methods)

Introduction This guide demos how to share folder in windows 10. It covers 3 methods. Options...
Configure Map Network Drive with Group Policy

Map Network Drive in Windows 10 with Group Policy

Introduction This guide demos how to map network drive with group policy. This guide is...

How to Map Network Drive in Windows 10 (5 Methods)

Introduction This guide demos 5 methods to Map Network Drive in Windows 10. Options to...
How to Download Windows 10 ISO with Media Creation Tool

How to Download Windows 10 ISO with Media Creation Tool

Introduction This guide demos the steps to download Windows 10 ISO. You can download Windows 10 ISO with Media...

How to Install Windows 10 from Network Boot (Via WDS Server)

Introduction This guide demos how to install Windows 10 from network boot. The steps discussed in...

Advertisement

MUST READ

Amazon Baby Registry

Amazon Baby Registry: Your Definitive Guide

Introduction Amazon Baby Registry allows expectant mothers to create a list of items they need for their baby. Friends...

How to Sign in to Windows 10 with a Microsoft Account

Introduction When you installed Windows 10 you may have created and signed in with a local account. You can...
DISM error 50: dism doesn't support servicing windows PE with the /online option

How to Fix DISM Error 50 in Windows 10 and Windows Server 2016

Introduction Dis you received DISM error 50: "DISM doesn't support servicing windows PE with the /online option"? This is...
Configure Group Policy for Windows Updates Server 2016 (WSUS Server 2016)

How to Configure Group Policy for WSUS in Windows Server 2016

Introduction This guide demos how to configure Group Policy for Windows Updates Server 2016 (WSUS Server 2016).
repair windows server 2016

2 Easy Options to Repair Windows Server 2016

Introduction This guide offers 2 quick ways to repair Windows server 2016. The method you use will depend on...

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