Google Sheets COUNTIF Function

The Google Sheets COUNTIF function is used to count items in a range that match a given condition.

For example, consider the following dataset of customer sales:

Countif Google Sheets

This formula counts how many times “John” is found in the range:

=COUNTIF(A2:A11,"John")

This one counts how many times “New York” occurs:

=COUNTIF(B2:B11,"New York")

And this one counts how many sales are over $500:

=COUNTIF(C2:C11,">500")

Continue reading Google Sheets COUNTIF Function

How To Get A Unique List Of Items From A Column With Grouped Words

This post shares my solution to a problem that I faced myself recently.

I needed the unique list of items from a column containing grouped words, separated by commas.

The data was in this format:

Grouped data in Google Sheets

As you can see, it’s a list of my online courses, but many of the rows contain more than one item, separated by commas.

Ultimately, I want to transform the data into this format:

Unique List Of Items

Continue reading How To Get A Unique List Of Items From A Column With Grouped Words

The UNIQUE Function in Google Sheets

The UNIQUE function in Google Sheets is a hugely useful function that takes a range of data and returns the unique rows and discards the duplicate rows.

Here’s a super simple example to show how it works:

Unique Function Simple Example

Here, the data from column A is passed into the UNIQUE formula and the unique values are returned.

Continue reading The UNIQUE Function in Google Sheets

The OR Function in Google Sheets

The OR function in Google Sheets is a logical function that outputs TRUE if at least one of the inputs is TRUE, and FALSE only if all the inputs are FALSE.

Or Function Truth Table

It has useful applications in data cleaning where it pairs well with the IF Function and AND Function to categorize and organize data.

Continue reading The OR Function in Google Sheets