View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
al al is offline
external usenet poster
 
Posts: 363
Default SUM PRODUCT ACROSS WORKSHEETS

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.