View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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