|

FEATURED POSTS

How to Change Outlook Password in 3 Different Ways

How to Change Outlook Password in 2 Easy Steps

Introduction Before you change your Outlook Password you have to first change it with your email provider. The reason...
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...
ForEach-Powershell

PowerShell ForEach: Syntax, Parameters, Examples

What is PowerShell ForEach? PowerShell ForEach (ForEach PowerShell) is a PowerShell construct used in iterating through values in a...

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...
PowerShell vs CMD

Powershell vs CMD: Differences and Similarities Compared

Introduction This short guide compares PowerShell vs CMD (Windows command prompt). I will cover the history and nature of...
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

inaccessible boot device server 2016 fix

How to Fix Inaccessible Boot Device Error in Windows Server 2016

Introduction Some Windows admins have reported receiving "inaccessible boot device" error in Server 2016 after a Windows update. If...
How to Convert Text to Number in Excel

How to Convert Text to Number in Excel in 4 Easy Ways

Introduction There are 4 ways you can convert text to number in Excel. This guide demonstrates the 4 ways...
how to change wifi password

How to Change Wifi Password for Any Wifi Router

Introduction To change your Wifi password (PIN), you need the IP address and admin login for the router. Once...

Powershell If Else Explained: Syntax and Examples

Introduction PowerShell If Else statement runs a command if a specified condition is met. The Else part of PowerShell...
command prompt commands

20 Command Prompt Commands for Sys Admins

Introduction Here is my ultimate list of command prompt commands for very serious Windows Systems Administrators. For each command,...

RECENT POSTS

how to merge cells in excel

How to Merge Cells in Excel in 2 Easy Ways

Introduction You can merge two Cells in Excel using CONCATENATE function or the “&” (ampersand) operator. Though Excel has...
How to Make a Pivot Table in Google Sheets

How to Make a Pivot Table in Google Sheets

Introduction You can make a Pivot Table in Google Sheets to simplify analysis of complex data. A Pivot Table...
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...
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....
RAID 5 vs RAID 6

RAID 5 vs RAID 6: Differences, Benefits and Disadvantages

What is RAID 5 vs RAID 6? RAID 5 and RAID 6 uses striping with distributed parity technique. However,...
concatenate excel

Concatenate in Excel: How to Concatenate Columns and Strings

What is Concatenate in Excel? Concatenate in Excel is joining two strings into one continuous string. You can join...

How to Add in Excel (Excel Sum) with Examples

Introduction There are different ways to add numbers in Excel. You could simply select the cells containing the data....
Excel Count

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,...
powershell.exe -command

Powershell.exe Command: Syntax, Parameters and Examples

Introduction You may be wondering why write on Powershell.exe Command. Are there special commands for Powershell.exe? Yes! When you...
how to move columns in excel

How to Move Columns to Rows and Rows to Columns in Excel

Introduction If you receive some Excel data in columns, you can easily move the columns to rows in Excel...

MUST READ

Gmail Mark All as Read: How to Mark all Emails as Read on Gmail

How to Mark all Emails as Read on Gmail

Introduction If you receive a lot of emails that you do not wish to read, you may want to...
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...
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...
windows was unable to complete the format

Windows was Unable to Complete the Format [Fixed]

Introduction When you try to format a USB stick or SD memory card you may receive the message "Windows...
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...

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

YOU MAY ALSO LIKE:

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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