Hi there,
Recently, I have completed one batch of MASTER@HOME program and in the mean time I gave a question to my students related to the post title. The question is Sum the values in column C based on the values >30 and the values <65? I selected this question randomly based on the data availability while giving basic training . This question should actually be listed in advanced formulas because this can be achieved by using SUMIFS function.
If you know how to sum based on two conditions, please do post your formula in the below comments section (take random values to sum). If you want to learn how to do this, please step with me.
...
SUM ONE COLUMN with TWO CONDITIONS:
To sum the values based on one condition, we can use SUMIF function similarly for two conditions, we can use SUMIFS.
Here we go:
BRIEF ABOUT SUMIFS (in a story format):
Let me frame a love story now. Say SUMIFS is a boy and he has 127 friends and each of them has a girl friend. There names are criteria range 1, criteria 1, criteria range 2, criteria 2, .......criteria range 127, criteria 127. However two of them are willing to marry since year 2013. let's not reveal their age so, we assume they might be between 30 and 65. Now, in this new year, they planned to get married in a church where the father of the church is SUMIFS.
Hey! we missed to know the address of the two newly marrying couple. The address is D2:D13. Now, we will see how SUMIFS showered his love to both of them for getting married.
=SUMIFS(sum these values, based on this range, with condition which is morethan value 30, and then search another criteria in this criteria range 2, to sum values based on second condition, which is lessthan or equal to 65)
That's it.
DID YOU USE SUMIFS?
Please teach us how you use SUMIFS in your work using below comments section.
If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog.
If you like to receive such posts to your email id, REGISTER your email id with us. We love information security.
SOME IMPORTANT LINKS:
Thanks,
Recent comments