Hi

You could carry out the Sumproduct on each individual sheet in an area to
the right of your data, say cell X1 onward
Then create 2 new sheets called First and Last, and drag these to a position
which "sandwiches" your 4 data sheets e.g.
Summary, First PC, OZ, IM, KL, Last

On the summary sheet then you can just use
=SUM(First:Last!X1)
The sheets First and Last can be hidden once you have placed them in their
correct location
--
Regards
Roger Govier

"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:8439538dffe8a@uwe...
I have four worksheets as follow: PC, OZ, IM and KL; each of the worksheet
is
containing data.

In another separate worksheet is performing the analytic function. In this
worksheet, only one type of excel formular is applying:
SUMPRODUCT(--(x=x),--
(y=y),--(z=z),(A:A).

Because there are four worksheets, I need to set four formula as following
in
one cell:
SUMPRODUCT(--(x=x),--(y=y),--(z=z),(A:A)+SUMPRODUCT(--(x=x),--(y=y),--(z=z),
(A:A)+SUMPRODUCT(--(x=x),--(y=y),--(z=z),(A:A)+SUMPRODUCT(--(x=x),--(y=y),--
(z=z),(A:A)

I feel above formula is a very very long formula and make the size of the
Excel file very huge.

My question is that is there any way to make ONE Excel formula to cover
the
four worksheets and at the same time still allow to perform SUMPRODUCT
function?

Many thanks,
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200805/1