Thanks T. Valko

The sheets have a lot of data from cells d10 to w300 which need to be
multplied to get the Net number.

Working out the net in the sheets would double up my data which I do not
need as I am only interested in the Net numbers on the case I am running.


"T. Valko" wrote:

Oh, ok. I misunderstood.

Well, there's no easy way to do that with a single formula. It could be done
but the resulting formula would be long, complex and require you to list
your sheet names.

I would just use a formula on each sheet in the same cell like this:

Cell X1: =A1*Y1

Then you can do a simple sum like this:

=SUM(start:end!X1)

--
Biff
Microsoft Excel MVP


"Jolly" wrote in message
...
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