If you already know the very basic SUM FUNCTION , this SUMIF function is an advanced version of that, letting us to put a condition on our summation.
SUMIF function is a mathematical function which is found in Google Sheets.
This function is very useful in a case when there is one principle condition, on the basis of which a final calculation needs to take place.
SUMIF FUNCTION LETS THE USER CONTROL THE SUM BASED ON THE GIVEN CONDITION. WHICH MEANS, WE CAN SPECIFY WHEN TO SUM AND WHEN NOT TO SUM.
The article would take you through the purpose, syntax and a few examples of using SUMIF FUNCTION in GOOGLE SHEETS.
SUMIF function adds us the different given values or a range only if a particular criteria is met, otherwise it rejects the calculation.
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
The Syntax for the function is
=SUMIF(LOOKUP_RANGE, CRITERIA, SUM_RANGE)
The following animated picture shows the steps to use the SUMIF FUNCTION in GOOGLE SHEETS followed by the explanation.
The example contains the ages as 23,25,18,30.
We’ll use the function as
First argument is E5:E8 i.e. our lookup range which is AGE in our case , where we would put the criteria.
Second is the criteria, which is >25 i.e. age should be greater than 25. use “” to put the criteria.
Third range is our sum range, which would we sum as per the criteria and result will be from the sum range.
The result comes out to be 6000 which is the tax paid by the person aged 30 as he is the only one >25 in the group.
It is not always necessary to use all the three arguments. If our lookup range and sum range are same, we can still use SUMIF.
Let us take the same example and find out the income of people where income is greater than 150000.
The data again in same.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE