View Single Post
  #3  
Old September 25th, 2003, 04:43 AM
external usenet poster
 
Posts: n/a
Default Help with a formula.

Thanks, that did the trick.

-----Original Message-----
You have 51 worksheets and you want the sum of the the
same cell. Let's say the cell is a1.

=sum(sheet1:sheet51!a1)

-----Original Message-----
I am trying to simplify a formula on a worksheet that
sums the same cell on 50 other worksheets all within

the
same workbook. I can do it the long way of inputing
the "worksheet"!cell for each worksheet but isn't there

a
shortcut for doing this?

Thank-you and if you reply by e-mail that would be a

help.
.

.