View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
=SUM('sheet1:sheet12'!A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"TNMAN" schrieb im Newsbeitrag
...
I have a workbook that contains 12 worksheets of identical

data/format and a
13th worksheet I would like to provide totals of the 12 monthly

worksheets.
Is there an easy way to write this sum formula without going to each
worksheet. I am using version 2003. Thanks in aadvance for you

help.