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.
Similar Reading: How to use SUMIFS function in Google Sheets?
Split the word sumif. Then you can see it’s sum, if. That means the function used to add values based on a condition.
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.
Advanced Use of SUMIF function in Google Sheets
Here I will explain you how to use this function to take the stock balance. I’m not going to it in detail. This is to just make you understand some situation where you can use SUMIF function in Google sheets.
First create a sample database of stock in a sheet. Then create another database where you show the issue or usage. Now in the first data base, take the total usage against each item using Sumif. Here criterion will be in data base 1, range and sum_range will be in database 2. Now in database 1, you will get total stock and issue quantity.
You may also like: How to Do a Case Sensitive SUMIF in Google Sheets
Hope you understand. If you have any query regarding the advanced use of sumif function, whether in Excel or Google sheets, please use the comment form below to reach me.