The Google Sheets COUNTIFS function is used to count items in ranges with multiple test criteria.
It works like a COUNTIF function, but lets you include more than one conditional test.
Here’s an example with a small real estate example dataset:
How can we count the number of deals for apartments and buyers?
To count them, we use a COUNTIFS function:
=COUNTIFS(B2:B11,"Apartment",C2:C11,"Buyer")There are three rows that are apartments AND buyers, highlighted in yellow.
The Google Sheets Query function is the most powerful and versatile function in Google Sheets.
It allows you to use data commands to manipulate your data in Google Sheets, and it’s incredibly versatile and powerful.
This single function does the job of many other functions and can replicate most of the functionality of pivot tables.
This video is lesson 14 of 30 from my free Google Sheets course: Advanced Formulas 30 Day Challenge
Continue reading Google Sheets Query function: The Most Powerful Function in Google Sheets
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:
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")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:
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:
Continue reading How To Get A Unique List Of Items From A Column With Grouped Words
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:
Here, the data from column A is passed into the UNIQUE formula and the unique values are returned.