spread sheets - adding

U

UCHA

How can I add the same cell of diverse contiguous spread sheets; example:
(Pla1 H1 + Pla2 H1 + ...). the formula is: [=(Pla1!H1;Plan2!H1; ...)];
however, if I will add many spread sheets (50), the formula will be extremely
great. How can I simplify the formula?
 
A

Allllen

=SUM(Pla1:pla50!H1)

This works for all the sheets as you see them at the bottom of your screen.

So if you have a Pla42, but on your screen it comes after Pla50, it wouldn't
be included.

However, if you have a sheet called "Frog" and it is somewhere on your
screen between Pla1 and Pla50, then it would be included.

Play with it and see how nice it is.
 
D

Dave Peterson

I'd use the same kind of technique that Alllen suggested, but I would insert a
new worksheet to the far right (name it Finish) and one to the far left (name it
start).

Then put the summary worksheet to the right or left of this "sandwich" of
worksheets.

=sum('start:finish'!h1)

And if you want to play "what if" games, you can drag any of those worksheets
outside that sandwich to see how the sum changes.


How can I add the same cell of diverse contiguous spread sheets; example:
(Pla1 H1 + Pla2 H1 + ...). the formula is: [=(Pla1!H1;Plan2!H1; ...)];
however, if I will add many spread sheets (50), the formula will be extremely
great. How can I simplify the formula?
Click to expand...
 
Top