Add up worksheets

K

Kate

I have 30 worksheets in one workbook I need to add cell F26 from each sheet
and add them up in sheet 31. Is this possible?
Thanks Kate
 
B

Bob Phillips

=SUM('Sheet1:Sheet30'!F26)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
K

Kate

Thanks Bob it does help

Kate
Bob Phillips said:
=SUM('Sheet1:Sheet30'!F26)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
Top