Summarizing monthly worksheet totals

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
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
 
Back
Top