Use Of Sumifs
Sumifs is the conditional formula. This is the fantastic formula in excel when we have data in bulk and we have to find out the result with multiple comdition. As the name of the fourmula is SUMIFS (sum+ifs). We use this function in when we want to sum.
For Example:- we have some salesman and we want to find out that how much they did sale in the particular period by each sales man.
Syntex:- sumifs(Sum range, Criteria_range1,criteria_range1,Criteria_range2,criteria_range2)
Sum range:- The actual cellto add, if you want to add other than those specified in the range argument.
Range Required:- The range of the cells that you want evaluated by criteria, the range must be number, names or array or reference that contain numbers.
Criteria Required:- The criteria is in the form of number, expression a cell reference, text or a function that define which cell will be added.
Sum range = The range to be sum
Range1
= The first range to evaluate.
Criteria 1
= The criteria to use on range1
Range2
= The second range to evaluate
write here salesman and the model
of mobile. You can see the result in the next image. if you want to apply the
formula in next cell copy the formula and paste in next cell or drag down the
formula.
No comments:
Post a Comment