Before going to learn the use of SUMIF function in google doc spreadsheets 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 a possible simplest way.
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.
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.
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 colum “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.
Here I will explain you how to use this function to take the stock balance.
First create a database of your stock in a sheet.
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.
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.