SUM product of multiple sheet

[blue_lagoon]

Hello,

I have 10 identical sheets- 9 sheets are having data and the 10th one is master summing all values from sheet 1 to sheet 9.

I'm trying to sum the product of values in c9 and c15 in every 9 sheets and showing the sum in cell c15 in the master sheet.

Appreciate help for the formula.

Thanks,

Jenni

 

[Joe4]

Welcome to the Board!

Try this:

=SUM(Sheet1:Sheet9!C9) + SUM(Sheet1:Sheet9!C15)

(where "Sheet1" is the name of your first sheet and "Sheet9" is the name of your 9th sheet).

 

[blue_lagoon]

Thanks, Joe4!

by the given code, it will only sum all the values in c9 and c15 for all the 9 tabs. Whereas I need a formula which can add the product of values in cell c9 and c15 each of 9 tabs in cell c15 on the master tab.

Appricite for your help!

Welcome to the Board!

Try this:

=SUM(Sheet1:Sheet9!C9) + SUM(Sheet1:Sheet9!C15)

(where "Sheet1" is the name of your first sheet and "Sheet9" is the name of your 9th sheet).

 

[Joe4]

OK, sounds like you may need something like a 3D SUMPRODUCT formula.
I am really have not done that much, but see here: https://exceljet.net/formula/3d-sumif-for-multiple-worksheets