How to Use Conditional Summing for Specific Conditions

If we want to find out the numeric value then the lookup function may be not the best option because we have to use helper column or array formulas. The easiest approach would be to use SUMIFS function which is designed to add up values from numbers & include only rows that meet the given condition.

 

Let us understand with an example:

  • We have a sales report that contains 3 Years, 3 Regions & 3 Sales Rep.
  • In column F & G, conditions are specified

 

img1

 

  • We need a formula to check all the conditions to produce the result.
  • In cell G5, the formula would be: =SUMIFS(D2:D16,A2:A16,G2,B2:B16,G3,C2:C16,G4)

 

img2

 

In this way, we can sum based on the meeting all the specified conditions.

xlsx-1567

Download – How to use Conditional Summing for Specific Conditions – xlsx

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube