Hi; I'd like to get the sumproduct of two cells, d19 and d20, across
worksheets. For instance, Lets say there are two worksheets; The first
worksheet is 10 and the second one is 14. Thus, I've tried using the
following formula:

=SUMPRODUCT('10:14'!D19:'10:14'!D20)

which produces an error.

Thanks in advance.

Hi Al,

In sheet1, cells D19 & D20, I have 1 & 2, in sheet2, cells D19 & D20, I have
3 & 4. Using =SUMPRODUCT(Sheet1!D19:D20,Sheet2!D19:D20) on sheet3 I get 11. I
am not sure this will help you or not, but it appears to be working to me.

Thanks,


"Al" wrote:

Hi; I'd like to get the sumproduct of two cells, d19 and d20, across
worksheets. For instance, Lets say there are two worksheets; The first
worksheet is 10 and the second one is 14. Thus, I've tried using the
following formula:

=SUMPRODUCT('10:14'!D19:'10:14'!D20)

which produces an error.

Thanks in advance.

David:

Thanks for responding. What I need is for the values in D19 across sheets
to be multiplied by the values in D20 across sheets, and then summed. So
using your example, I'd like to see

(1*2)+(3*4)=14

Do you know if this is possible?


"David" wrote:

Hi Al,

In sheet1, cells D19 & D20, I have 1 & 2, in sheet2, cells D19 & D20, I have
3 & 4. Using =SUMPRODUCT(Sheet1!D19:D20,Sheet2!D19:D20) on sheet3 I get 11. I
am not sure this will help you or not, but it appears to be working to me.

Thanks,


"Al" wrote:

Hi; I'd like to get the sumproduct of two cells, d19 and d20, across
worksheets. For instance, Lets say there are two worksheets; The first
worksheet is 10 and the second one is 14. Thus, I've tried using the
following formula:

=SUMPRODUCT('10:14'!D19:'10:14'!D20)

which produces an error.

Thanks in advance.

Hi Al,

To get 14 this is what I had to do, which is not what you want i think,

Sheet1, Cell D19 = 1, E19 = 3
Sheet2, Cell D20 = 2, E20 = 4
Sheet3, Cell F19 formula '=SUMPRODUCT(Sheet1!D19:E19,Sheet2!D20:E20)

Thanks,

"Al" wrote:

David:

Thanks for responding. What I need is for the values in D19 across sheets
to be multiplied by the values in D20 across sheets, and then summed. So
using your example, I'd like to see

(1*2)+(3*4)=14

Do you know if this is possible?


"David" wrote:

Hi Al,

In sheet1, cells D19 & D20, I have 1 & 2, in sheet2, cells D19 & D20, I have
3 & 4. Using =SUMPRODUCT(Sheet1!D19:D20,Sheet2!D19:D20) on sheet3 I get 11. I
am not sure this will help you or not, but it appears to be working to me.

Thanks,


"Al" wrote:

Hi; I'd like to get the sumproduct of two cells, d19 and d20, across
worksheets. For instance, Lets say there are two worksheets; The first
worksheet is 10 and the second one is 14. Thus, I've tried using the
following formula:

=SUMPRODUCT('10:14'!D19:'10:14'!D20)

which produces an error.

Thanks in advance.