View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jolly Jolly is offline
external usenet poster
 
Posts: 19
Default Adding worksheets using sumproduct function gives error

Thank you Biff but that does not give the correct answer.

It adds the two sets first and then multiplies whereas I need each item
multiplied first and then added.

Please help.

"Jolly" wrote:

Hi

I usually add together worksheets using:

= sum(start:end!a1)

which is fine but when I tried to use the sumproduct function:

=sumproduct(start:end!a1,start:end!y1)

where a1 has the gross data input and y1 has the working interest but this
gives me #ref error

I am trying to consolidate multiple worksheets which have gross data input
but I want to add the net data using the working interest in each sheet.

All the data input and working interest cells are in the same location in
each sheet.


I would appreciate any guidance to solve this problem
Many Thanks
Jolly