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
|