If the sums to be totalled are all in the same cell in each worksheet
=sum(firstsheet!:lastsheet!a1)

--
Don Guillett
SalesAid Software

"NAAPS" wrote in message
...
I need to add totals from many worksheets onto one final Summary worksheet.
the formula I create is too long for Excel. is there a way to shorten the
formula eg using the SUM function + Shift or Control keys? I believe
Lotus
is able to do this.