Sumif and SumProduct function across multiple worksheets and multiple criteria

How would I sum values from three different worksheets in the same workbook, if multiple criteria is met?  In the attached Example, I would like to add the total results to the Main worksheet, for the month for each category (Wood, Metal, Plastic, and Misc).

Hi,

In cell B3, enter this formula and copy down/right

=SUM(Tony:Joe!B2)

Hope this helps.

Regards,

Ashish Mathur
www.ashishmathur.com
http://twitter.com/excelashish

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thank you for the response.  This works, but I am looking for a way to ensure if users move columns or rows around on the secondary worksheets that I have conditions (criteria) - i.e. column name and month match then sum the results.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi,

As long as months remain in the same order on all the worksheets (the order of rows may change), my solution at this link should work.

Hope this helps.

Regards,

Ashish Mathur
www.ashishmathur.com
http://twitter.com/excelashish

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Excel 2010 with free PowerPivot and Power Query Add-Ins.

Compatible with Office 2013 Pro Plus and later.

No formulas, no VBA macro.

Flexible.

Dynamic.

Hard.

http://www.mediafire.com/download/i39fdwi48hsqru4/10_27_15.xlsx

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 5, 2019 Views 146 Applies to: