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”.
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.