COUNTIF Function

How to Use Wildcard with IF Condition in Google Sheets (3 Ways)

Knowing how to use Wildcard characters is a great tool to possess while working in Google Sheets. Wildcards can help you maximize your search ...

How to Remove Both Duplicates in Google Sheets (2 Easy Ways)

Removing duplicates is a common task in Google Sheets or Excel operations. But, the first occurrence of each duplicate generally remains when we use ...

How to Use Formula to Highlight Duplicates in Google Sheets

When a dataset has duplicate quantities, you may wish to highlight those duplicates to visualize the dataset. You may wish to highlight those ...

How to Remove Duplicates in a Column in Google Sheets (5 Ways)

When using Google Sheets, you could come across large spreadsheets with several duplicate entries. We understand how annoying it is to deal with ...

­How to Remove Duplicates in Google Sheets Using Formula

While working on Google Sheets, datasets may contain duplicate values. For small datasets, you can manually remove the duplicates. But, this will ...

How to Find and Remove Duplicates in Google Sheets (5 Ways)

Sometimes we fell into such a situation when we have a dataset that has some duplicate values in it. If we calculate keeping the duplicate values, ...

Google Sheets: Sum of Cells with Text (4 Examples)

In this simple tutorial, we will look at a few example scenarios where we sum cells with text or those that depend on text in Google Sheets. Note ...

How to Count Cells in Google Sheets (4 Easy Ways)

Being one of the most fundamental processes, there are multiple scenarios where you’d count cells in Google Sheets: Count Empty Cells Count ...

Find Value in a Range in Google Sheets (3 Easy Ways)

Today, we have a look at how we can find a value in a range in Google Sheets. The idea is simple, and we have a few approaches in mind that we can ...

How to Count Unique in Google Sheets (3 Easy Ways)

Today, we will look at a few ways we can count unique entries in Google Sheets. While the idea is simple, it also means that there can be multiple ...

Compare Two Columns for Duplicates in Google Sheets (3 Easy Ways)

Today we will look at a few ways to compare two columns for duplicates in Google Sheets. While the idea is simple, we can have multiple scenarios ...

Using Conditional Format to Compare Two Columns in Google Sheets

Today we are going to specifically look at how to compare two columns using conditional formatting in Google Sheets. Let’s get started. 2 ...

Count Non-Empty Cells in Google Sheets (4 Easy Ways)

The ability to recognize and count non-empty cells in Google Sheets is very crucial if you are looking to avoid some silly errors. And today, we will ...

Using COUNTIF to Count Non-Blank Cells in Google Sheets

Counting non-blank cells in a spreadsheet is a fairly common affair at every level of the profession. There are many ways to go about it. But today, ...

COUNTIF Contains Text in Google Sheets (4 Ways)

In a practical scenario, you will often have huge amounts of data in your spreadsheets. In such a situation finding certain text in this huge ...

OfficeWheel
Logo