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.
.
.
|