Also note that Sheets 2 - 79 must be physically located between Sheets 1 & 80 for this to work.

--
Cheers
macropod
[Microsoft MVP - Word]


"Don Guillett" wrote in message ...
try this. Best to set up a dummy 1st and last sheet so that if you
add/delete sheets, OK
=SUM(Sheet1:Sheet80!e12:e50)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Todd Hudson" wrote in message
...
I have a workbook with 80 worksheets. I want to add column E12 thru column
E50 across all worksheets, then total up those numbers.

Any ideas if this is possible?

Thanks,

Todd