Sumproduct across sheets issue

I´m just starting in this group. (I beg your pardon in advance for my terrible English)

My problem is, how can I proceed for use SUMPRODUCT in 3-D ranges?

For example, consider that I have sheets named A, B, C, D

I want to do something like this:

=SUMPRODUCT(A:D!E3;A:D!E4)/SUM(A:D!E4)

giving the medium value of E3/E4


The problem is, that just doesn't work!, instead I recieve the #REF as a result


Is there a solution to workaround this issue?

Thanks in advance

Hello and welcome.
http://www.excelforum.com/excel-gene...-criteria.html

Here's what I think you want:

=SUMPRODUCT(N(INDIRECT({"A","B","C","D"}&"!E3")),N(INDIRECT({"A","B","C","D"}&"!E4")))/SUM(A:D!E4)

This is what that formula is doing:

(A!E3*A!E4)+(B!E3*B!E4)+(C!E3*C!E4)+(D!E3*D!E4)/SUM(A:D!E4)

You're welcome. Thanks for the feedback!