dynamic 3d sum

A

Avner

It Helps !

I have to understand what it means in order to keep c1=x absolute an
a1 relative so i can copy it across rows and columns.

thanks again
avne
 
D

Domenic

Try the following formula...

=SUMPRODUCT(SUMIF(INDIRECT("'"&ROW(INDIRECT("1:"&$C$1))&"'!"&CELL("address",A1)),"<>"))

OR

=SUMPRODUCT(SUMIF(INDIRECT("'"&ROW(INDIRECT("1:"&$C$1))&"'!"&ADDRESS(ROW(A1),COLUMN(A1),4)),"<>"))

Hope this helps!
 
Top