All resources related to COUNT for Excel and Google Sheets.

All articles
COUNT

Count numbers third digit equals 3

As the title suggests that we need to count the numbers wherever the third digit of stepping of numbers is 3. can be done by combining the Excel built-in functions, the SUMPRODUCT function, and the mid function. Generic Formula =SUMPRODUCT(--(MID(count_range, 3,1)=”3”)) How does this formula work? Firstly, the innermost function...

Count cells equal to

Figure 1. of the Count Cells Equal To Function in Excel. Let's say we have a range of data values in our Excel sheet, and we want to count how many cells meet a specific criteria. This can be acheived through the COUNTIF function. This tutorial will step through the...

Two-way summary count with COUNTIFS

Excel allows a user to create two-way summary count by using the COUNTIFS function. This function allows us to count multiple columns. This step by step tutorial will assist all levels of Excel users in creating a two-way summary count. Figure 1. The result of the COUNTIFS function Syntax of...

Using COUNTIF to Find a Running Count of an Occurrence in a List

We can do a running (continuous) count of an occurrence in a list by using the COUNTIF function in combination with the IF function. The steps below will walk you through the procedure. Figure 1: Using COUNTIF to Find the Running Count of an Occurrence in the List Setting up...

Count Cells That Do Not Contain Errors

As we work on excel spreadsheets, a time comes when we need to count cells that do not contain errors. The NOT function together with ISERR function can be wrapped inside the SUMPRODUCT function to count cells that have errors. This post will step through how to count cells that...

How to Count Cells that Contain Negative Numbers in Excel

We can count cells that contain a negative number within a specified range of cells with the COUNTIF function. We will walk through the procedure by following the simple steps below. Figure 1: COUNTIF Function for counting negative and positive numbers Syntax =COUNTIF (range, “<0”) Formula =COUNTIF(A4:A9,"<0") Setting up the...

How to Count Unique Text Values in a Range in Excel

We can count unique text values in a range by using a combination of FREQUENCY, MATCH, ROW and SUMPRODUCT functions. We can also achieve the same result with the COUNTIF function. The steps below will walk through the process. Figure 1: Result of Count of Unique Text Values in a...

How to Count Unique Numeric Values with Criteria

While working with Excel, we are able to count unique numeric values in a data set by using the SUM, FREQUENCY and IF functions, with some help using the double negative “--”. This step by step tutorial will assist all levels of Excel users in counting unique numeric values based...

Count visible rows only with criteria

While working with Excel, we are able to perform calculations that consider only visible rows by using key functions such as SUMPRODUCT, SUBTOTAL, OFFSET, MIN and ROW. This step by step tutorial will assist all levels of Excel users in counting only visible rows with criteria. Figure 1. Final result:...

Count Cells That Contain Five Characters

While working with Excel, we are able to count values in a data set based on a given criteria by using the COUNTIF function. COUNTIF returns the number of values in a specified range based on a given condition. This step by step tutorial will assist all levels of Excel...