question on sumproduct

[siddharth_kale]

Hi,

I want to use the below formula with range of cells (D1:L1) from different sheets:

=SUMPRODUCT(SUMIF(A1:A7,D1:L1,B1:B7))

Could you let me know how this can be done?

Regards,
Siddharth

 

[Lewiy]

What is it that you actually want to achieve?

 

[machopicho]

Explaine better please

 

[brentix]

I think your looking for a link as in red

=SUMPRODUCT(SUMIF(A1:A7,'sheetname'!D1:L1,B1:B7))

you would either need to nest a range of links or create a data range of link with a sum total