# Simplified the Use of SUMIF function in Google Sheets

0
660

Before going to learn the use of SUMIF function in Google Sheets let me tell you one thing. It’s a very handy function which I often use in Excel as well as google sheets. You can find tons of tutorial which explain the use of sumif function in Google Sheets. As a beginner, you may find it difficult to understand. If you want to learn the use of this handy Google Sheets function, first you should understand where to use it.

Let me explain the use of SUMIF function in the possible simplest way with examples.

Split the word sumif. Then you can see it’s sum, if. That means the function used to add values based on a condition.

## SUMIF Example

See the example below. Create a sample data base as shown below. With the example only you can learn the use of SUMIF function in Google Sheets.

Now let me explain. When you filter the column “A”, that means field name “product name” with “tv”, and total the field “Qty. Sold”, you will get the answer 20. The same you can get from using the function SUMIF.

### Syntax of SUMIF in Google Sheets

SUMIF(range, criterion, [sum_range])

Here range is column “A”. Criterion means the condition which you type anywhere, here “tv” and select it. Sum_range is the column “B”.

The formula will be like this.

=sumif(A2:A6, B10, B2:B6)

From this I think you can clearly understand the concept of how to use Sumif function in Google Sheets.

If you understand the above step by step use of sumif function in google doc spreadsheets, below you can see where Sumif function can be dramatically used.