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
Thanks for implementing suggestion regarding posting of downloadable sample file. Hope this will continue so that users can take benefit.
Yes Tom. You file is very useful.