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