Adding multiple sumproducts

[will235]

I have a series of sumproduct outputs that i need to add together and was wondering if there was a simpler option than the below:

Please Login or Register  to view this content.

I expect the datasets to grow making adding one at a time problematic.

Thanks.

[Limor_OP]

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.