Tom’s Tutorials For Excel: Summing For Multiple Conditions

Tom’s Tutorial For Excel: Summing For Multiple Conditions

When you need to sum, average, or analyze data based on more than one condition, the SUMPRODUCT function is an excellent tool for the job.

The pictured table shows an example of sales activity in the widget industry that includes several different regions, companies, and prices. SUMPRODUCT helps you see “how much of this” depends on “these and those” or “these and those and them”.

Download the free example workbook

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
2 comments on “Tom’s Tutorials For Excel: Summing For Multiple Conditions
  1. Kundanlal Manwatkar says:

    Thanks for implementing suggestion regarding posting of downloadable sample file. Hope this will continue so that users can take benefit.

  2. sandeep kothari says:

    Yes Tom. You file is very useful.

Leave a Reply

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

*