It would be much easier if you put your total in row 1 and then sum across
row 1.

--
HTH

Bob Phillips

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

"lanrcdd" wrote in message
...
I have a Workbook containing multiple Worksheets. Each Worksheet has the
same
number of Columns but different number of rows. The last row of each
Worksheet contains the Sum for each Column. Is there a formula that will
SUM
all of a given Column's totals for all Worksheets, even though the number
of
rows is different in each Worksheet?