getting a sum across multiple worksheets, then adding the numbers
Hi,
In your summary sheet, in cell E12 enter:
=Sheet2:Sheet80!E12
Copy this formula down to E50.
In cell E51 enter
=SUM(E12:E50)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Todd Hudson" wrote:
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
|