Sign in Subscribe

Google Sheets Functions

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.

Read next

How to Use REGEXMATCH Function in Google Sheets?

How to Use REGEXMATCH Function in Google Sheets?

Searching within tables is a common task when working with Google Sheets. With the REGEXMATCH function, we can easily find the answer to the question of whether there is an exact match for the word we are looking for in a table. We can easily search with 'Find and replace'.

How to Use VLOOKUP Function in Google Sheets?

How to Use VLOOKUP Function in Google Sheets?

When working with Google Sheets, we can have multiple tables, multiple sheets, or multiple workbooks. Among these, we may need to work with identical columns and corresponding columns. For example, product codes, product names. We may need to use them on multiple pages. Instead of moving columns every time, we

How to Use the UNIQUE Function in Google Sheets?

How to Use the UNIQUE Function in Google Sheets?

When working with Google Sheets, we may have written the same data in our worksheet more than once. If there are few rows and columns, we can handle this one by one. But this becomes very difficult when working with very large tables. Suppose there are multiple duplicate data in

How to Use SUMIFS Function in Google Sheets?

How to Use SUMIFS Function in Google Sheets?

Mathematics is pretty easy when working with Google Sheets. Addition, subtraction, multiplication. While performing operations on these, the functions work with the whole column or the cell range you specify. What if we want to give a condition at the same time while doing the addition? With SUMIF we can

How to Use ROUND Function in Google Sheets?

How to Use ROUND Function in Google Sheets?

When working with Google Spreadsheets, our tables can have decimals. Working with them is pretty easy in Google Spreadsheets. However, we often want to get rid of them for ease of reading and to avoid image crowding when displaying in graphics. We use the Round function to perform this function.

How to Use SPARKLINE Function in Google Sheets?

How to Use SPARKLINE Function in Google Sheets?

When working with Google Sheets, we sometimes show our table with the help of graphs for ease of reading. Graphs help us a lot for both ease of reading and analysis. Well, imagine that you made these graphs for the rows only, not for the whole table. This is great.

How to Use IMPORTXML Function in Google Sheets?

How to Use IMPORTXML Function in Google Sheets?

With Google Spreadsheets, we can easily retrieve data from the pages we browse on the internet. We can take data from a second-hand site we look at, examine it, and even show it on a graph. All we need to know here is the function syntax. The IMPORTXML function requires

How to Use IMPORTRANGE Function in Google Sheets?

How to Use IMPORTRANGE Function in Google Sheets?

When working with Google Sheets, we can have multiple tables, multiple sheets. We may need to use the same data on different pages. You may think of getting data with copy-paste. But this would not be a tiring and continuous practice. We can easily make this application with IMPORTRANGE. If

How to Use IMAGE Function in Google Sheets?

How to Use IMAGE Function in Google Sheets?

When working with Google Sheets, we can easily add images to our sheet. We can fit it inside the cell or add it on the page. The syntax is pretty simple. Let's explain the syntax and how the function works through the example below. What is the syntax of the

How to Use GOOGLEFINANCE Function in Google Sheets?

How to Use GOOGLEFINANCE Function in Google Sheets?

With the GOOGLEFINANCE function, we can easily transfer our data from the Google finance web application to our worksheet. We can receive real-time foreign exchange and financial information daily, and we can track stocks. In addition, we can get historical securities data, show them with graphics and easily share what