### Best Ways to Use COUNTIF in google sheets : 2022

Google Sheet, Spread Sheet Often, stockholders request to reformat and summarize data to process and analyze instead of large data build. For example in sales

Skip to content
# Top 7 Google Sheets Formulas Every Beginner’s Should Know

Written by Amy Brink Technically reviewed by Channa S Bandara.

Publish Date : April 28, 2021 | Review Date : April 29, 2021
** Google sheets formulas must start with an equals sign (=) and the function need to define inside the curly bracket.**
**Google Sheets pre-defined formulas**

**Hey, I'm Never use Google Sheet Before **

**#1. SUM() formula in google sheets**

**How to use SUM() formula in google sheets (Basic Example)?**

**#2. SUMIF() formula in google sheets**

**weather**: අවස්ථාව, කාලගුණ, කාලගුණය, කුණාටුවට හෝ අමාරුවට අසුවී අනතුරට නොපැමිණ බේරෙන, දේශගුණය
**How to use SUMIF formula in google sheets (Basic Example)?**

**#3. COUNT() formula in google sheets**

**#4. COUNTIF formula in google sheets**

**How to use COUNTIF formula in google sheets (Basic Example)?**

**#5. IF formula in google sheets**

**#6. ****IFERROR Formula ****in google sheets**

**#7. ****ISBLANK Formula in google sheets**

######
Table of article :

###
Best Ways to Use COUNTIF in google sheets : 2022

Google Sheet, Spread Sheet Often, stockholders request to reformat and summarize data to process and analyze instead of large data build. For example in sales

Read More »
###
How to use concatenate in google sheets 2022 : Easy Tips

Read More »
###
How To Transpose Data in Google Sheets: An Epic Guide 2022

Read More »
###
How To Insert Checkmark In Google Sheets (Best Tips 2022)

Read More »

Publish Date : April 28, 2021 | Review Date : April 29, 2021

Google spreadsheets, now becoming the most popular data management application that you can use to analyze, predict and manipulate data effectively and efficiently. This is fully open-source cloud base software and no need to install it on your computer. Most of the time you must deal with un formatting datasheet & it doesn’t have to spend additional time to reformat data manually. Google sheets introduce and maintain over **200** google sheets formulas and function to reduce rewrap time and work with google sheets without any hassle.

You are getting confused with google sheets, how and which area should need to cover, and how to become an expert in google sheets. This tutorial will cover what are the most useful google sheets formulas and how to implement them with examples.

In the previous google sheets version to implement query to execute the formula. But now, google sheets become smart, and most of the query formulas covert and pre-defined google sheets formulas. It is very helpful to reduce your study & manual query time and reuse the formulas without any hassle.

The most important thing is when you enter custom google sheets formulas into the cell ( you may need to Double-click on the cell you want to enter the google formulas), it popup & guide you on how may need to fit in depending on your data.

If you never use google sheets before, we highly recommend following these **How to use Google Sheets guidelines** which offer by the google Sheets team. it will contain how to create google sheet, how to share google sheets with other people you want any most stater guide kit.

This is the most used formula in every spreadsheet software. **sum formula** uses for return sum of a series of cells. In google sheet have the following terms.

- Your sum formula defines like this
**=SUM()** - If you assign a single value into the
**SUM formula**, will return the same value same as you applied. - If you supplied more than one value into the sum formula, make sure that each value separated by comma
**=SUM(value1, value2, value2, ….)**.

- Double click cell which you want to add sum query and enter (without double quote) ”
**=SUM(**)” .then you can see helper popup also will show on cell.move the mouse pointer to the top right in the toolbar then click*Quick tips:***Function > SUM.** - Then press
and select the cell which you want to supplier for**Ctrl Key**.**SUM Formula** - Now all cells automatically assigned to the SUM formula will separate by a comma.
- If you need to assign
**cell ranges**into sum formula.**Ctrl Key**and select cell which you need to start and then press the**Shift key**and select last value in cell range. Then close bracket )

**SUMIF() formula** is something like a combination of sum & if formulas in google sheets. Its use Returns a conditional sum across a range.

- make sure that
**SUMIF**only performs with a single criterion. There is no way to configure with multiple criteria. You need to replace**DSUM**instead of. - if your cell range validates with text against, then make sure that criterion must be a string.
- If your cell range validates with number against logical expression criterion will be applicable.
**Logical operator****Operator Name****Description****=**equal to

Compare criterion defined value to another value in the range

**>**greater than

Check whether criterion defined value greater than the value in the range

**<**Less than

Check whether criterion defined value less than the value in the range

**>=**greater than

Check whether criterion defined value greater than or equal to the value in the range

**<=**Less than

Check whether criterion defined value less than or equal to the value in the range

**<>**Not equal to

Check whether criterion defined value not equal to the value in the range

English – Sinhala

In the below example, we need to get the total mark of maths in every student in the classroom.

- Double click the cell which you want to show the total math mark, then insert the cell range against the criterion.
- Add criterion you want to execute against a range
- Add range which needs to sum.

**COUNT()** formula in google sheet all to return the count of the number (number of numeric) is specifically defined in named range. you may need to consider the following terms when you are dealing with **COUNT **formula,

**COUNT**formula only executes numeric values in the datasheet and text values are ignored.- Also,
**COUNT**formula executes all the numerical value which defined in the selected data**range**including numbers which appear more than once. - You can define cell value as
**Named Ranged**or individual value which separate by comma )

` ````
```COUNT(A2:A10,B2:B10,4,26)
COUNT(1,2,3,4,5,B6:B20)

This is also another most useful and important google sheet formula. **countif** formula uses to return conditional counts in range with a single criterion you may need to use COUNTIFS formula to return the count of a range depending on multiple criteria. Make sure that it only executes with a single criterion & no need to worry about case sensitivity. this formula mostly uses to highlight duplicate data in spreadsheets.

- The
**countif**formula operates base on the range. if the range contains text against, the criterion must be a string. - also if the range contains numbers to check against criterion, either number or string.
- all criterion need to define inside the double quote and any of the following operators:
**=, >, >=, <, or <=,**use to check whether the range cell is equal to, greater than, greater than or equal to, less than, or less than or equal to the criterion value, respectively.

In the above example, we created a simple spreadsheet which contains student mark in the classroom. We need to get,

- Number of marks count which got more than
**75** - Number of marks count which got less than or equal to
**55**

- Double click the cell which you want to show the answer then type =COUNTIF( “.then you can see helper popup also will show on cell).
- Then select the range you want to execute again countif criteria. You can also create dynamic named ranges using the google sheets function.
- Then insert your criterion operation to execute against the selected range.

This is the one of powerful logical operation formulas in google sheets. IF** formula** can be used to check condition whether is **OK **or **NOT **in selected cell or range. it will return a boolean value if it’s **TRUE **or **FALSE**. you can setup up a value base on the return value in the logical expression. For example, you can check exam passed of failed students based on their subject mark average using if condition operation.

- This operation can be expressed with
value in the datasheet.*string, numeric or boolean* **IF Formula**only operates with a single condition. It does not operate with**AND**or**OR**logical operation. You may need to use the**IFS formula**for multiple operations.

When you work with the formulas in google sheets. you may need to face diverse types of **errors** while executing it. This will happen when formula syntax does not fulfill the basic requirement. This will pain stakeholders because they willing to get meaningful results instead of unwanted errors.

So google sheets introduces a function called** IFERROR** for preventing unwanted **errors** & replace the meaningful value on a cell in google sheets.

This **IFERROR formula** can be used with any other function or formula which returns the value after execution.

**ISBLANK** formula can be used to validate cell value exit or not. this **ISBLANK() formula** will return * TRUE *if the value does not exist (empty) on the cell. either it will return as

` ````
```ISBLANK(value)
=ISBLANK("hello") // String value validation
=ISBLANK(3) // Integer value validation
=ISBLANK(A1) // Cell reference assing
=ISBLANK(A1:A4) // Named Range assign

this function will mostly use condition operation formulas such as IF operation. Usually, that condition operation will break when assing empty cell or value in a given range.

June 19, 2022

May 1, 2022

Google Sheet, Spread Sheet As a data analyzer every time you deal with unstructured data for different purposes which stakeholder needs. Sometimes you have to

January 6, 2022

Google Sheet, Spread Sheet Google sheets extremely powerful that built with over 200+ reusable functions and shortcuts. It allows to create table and fill data

January 6, 2022

Google Sheet, Spread Sheet Google sheets offer various formulas to implement with your data manipulation. Many times you have to implement checkboxes in google sheets.