please help

T

tzveti

Hi,
If somebody knew, please let me know, is it possible to su
automaticaly numbers from different sheets in an workbook? For exampl
if you have 30 sheets and want to sum the numbers which are i
square(i'm not sure for this word) wtih address H31 but in differen
sheets - how you may do this?

Thank you in advance.

Regards,
Cveti

Soryy for my bad english :
 
K

kraljb

=SUM(Sheet1:Sheet2!A1)

Although it only works if the sheets you are adding are in order (Yo
can't add together just Sheet1 and Sheet3 if Sheet2 is located betwee
them)
 
D

Don Guillett

=SUM(Sheet1:Sheet2!A1)
=SUM(firstsheet:lastsheet!A1)
all intervening sheets will also be summed
 
T

tzveti

Hi again,
I asked for help to sum numbers from different sheets in one workboo
with constant address. You gave me this formula
=sum(firstsheet:lastsheet!a1) but the excell didn't sum right. Wha
could be the reason for this. Some of the sheets were created by copin
some sheet and move it to the end. Could be this thing the reason?:mad:
The names of the sheets are the dates of the day were created. Fo
example : 03.03.06 . When i sum the las 3 sheets it worked but when
want to sum more it didn't work.

Thank you in advance
Cvet
 
D

Don Guillett

Why not create a sheet named first and always have it as the first sheet to
sum>create a sheet named last and have it always as the last sheet to sum.
Then use the formula.
 
Top