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.