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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF "value if false" not working 2
Copy addition formula of non-consecutive horizontal cells 2
dynamic 3d sum 1
Combining two formulas 0
List all tables, including document structure 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Dealing with a Pivot Table (when I don't want to) 0
sqlite-odbc write conflict 2

Top