Hi

Adding 2 blank sheets to the file will make a negligible difference to file
size - about 3Kb
It is when you add more data or more formulae that the file size increases.
Try it and see.

--
Regards
Roger Govier

"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:843b2029ba9f0@uwe...
Hello Roger,
Many thanks for your advice!

I understand your strategy. However, according to your way, it will
create
more worksheets and make the size of the file is much larger!

I want a formula which really make thing simple. Ideally, the SUMPRODUCT
can
sum up the data from various worksheets WITHOUT create extra worksheets
and
at the same time reduce the size of the file! That is what I want!

Many thanks for your effort!
Wilchong


Roger Govier wrote:
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
I have four worksheets as follow: PC, OZ, IM and KL; each of the
worksheet
is
[quoted text clipped - 22 lines]
Many thanks,
Wilchong

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