Summarizing monthly worksheet totals
 

I have a workbook of monthly sales worksheets w/ totals in the same rows &
cells on each sheet. How do I create tables on a summary worksheet listing
the total rows for each month?

Thx for your help, John

Summarizing monthly worksheet totals
 

Assuming your sheets are named Jan, Feb, Mar etc, and that your totals
are in cell B10 on each sheet, then put Jan in A1, Feb in A2, Mar in
A3 etc, then in B1 you can use this formula:

=INDIRECT("'"&A1&"'!B10")

Copy this down to B12.

Hope this helps.

Pete

On Apr 19, 10:20*pm, John wrote:
I have a workbook of monthly sales worksheets w/ totals in the same rows &
cells on each sheet. How do I create tables on a summary worksheet listing
the total rows for each month?

Thx for your help, John