HiDocs High-Quality Ghost Documentation Theme

How to Use COUNTIFS Function in Google Sheets?

Searching worksheets can be done manually with little data. If you have a large table in your worksheet, if you have multiple worksheets or even workbooks connected to each other, this work becomes quite tiring. For example, you have a supermarket dataset.

You wonder how many of 'x' items are sold per day. It would be terrible to count them one by one. You can find a detailed article on how to count under a certain condition here→ ” How to use the COUNTIF function in google sheets? “

In this article, we will explain how we can count under more than one condition.

Where is COUNTIFS used?

We will explain the COUNTIFS usage areas with examples and examine the syntax.

Using COUNTIFS in the text tables

Our table consists of texts. We are wondering about the situations where both “Art” and “Florida” conditions are met. For this:

Come to the cell where you want to print the result and type

=COUNTIFS(A: A, "Art", D:D, "Florida")

• A:A → The range of cells I want to search. (Cell range for condition 1st.) I can specify a specific range, as well as select the column. Just click on column A.
• "Art"→ 1st condition
• D:D→ Cell range for condition 2
• "Florida"→2nd condition

Using COUNTIFS in numeric tables

Our table consists of numerical values. This is a sales high school. We wonder how many items were sold with more than 5 and how many with profits over 200. For this;

Come to the cell where you want to print the result and write

=COUNTIFS(B:B,"<5", E:E,">200”)

• B:B→ Range of cells I want to search.
• "<5"→ 1st condition. How many products were sold more than 5?
• E:E→Range of cells I want to search.
• ">200"→ 2nd condition. How many products have more than 200 profits?

Using COUNTIFS in date tables

=COUNTIFS(B:B;">5",C:C,">8.06.2015")

With this example, we look at the number of sales greater than 5 and how many sales were made after 8.06.2015.

• B:B→  Since I am looking for sales numbers greater than 5, I search for column B. That is, the cell range I searched for for the first condition.
• “>5”→ I'm looking for those with sales greater than 5
• C:C→  I am searching on the date column because I entered a date condition. So the range of cells I'm searching for the second condition
• “>08.11.2017” → My second condition. I'm looking at sales after that date.
Make your business data transparent!
• Subscribe to a package

Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

• Request unlimited dashboards

You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

• Your Data Studio Department

Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.