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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totaling cells based on input value 1
Use Workbook tabs in a Worksheet 1
Excel "Worksheet Name" Building Function for Summary Sheet 2
link few worksheets in one summary sheet 1
Summary Worksheet. 1
Excel Count If Formula Question 1
Link to the FIRST worksheet 3
Lookup function/sum function 24

Back
Top