Total Across Pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel spreadsheet that has pages 1-12, which is a two year budget
of items per category (there are 12 categories). I want to make a MASTER
sheet that includes the total row of each of the 12 sheets. How do I
populate the fields on the MASTER sheet from the other pages?
 
MamaHart,

Let us assume that you current sheets have tab names called 1, 2, 3.. 12.

Let us also assume that the data you want exists in Row 1 and Column A, B, C
(in the individual sheets).

Insert a new worksheet (Insert, worksheet)

Insert headings in your new sheet in row 1 and Columns A to J (if required).

In Row 2, Column A enter = (equal sign) then using your mouse go to the
sheet that you need to bring the data from and in the cell that has the
figure you want hit enter.

You should now notice that the figure from that sheet will now appear in Row
1 Column A.

Repeat the above for all 12 sheets and you should have a MASTER sheet.

For your information with your cursor in row 1 column A, look at the formula
bar it will read something like =’sheetname’!cell number.

HTH
 
Hi

assuming that your total row in each of the 12 sheets (and by sheets you
mean separate worksheets, not "printable" pages within a worksheet) is in
the same place (e.g. row 20), on the master sheet you can use a formula e.g.
=SUM(Jan:Dec!A20)
this will add up from the sheet called Jan to the sheet called Dec
everything that is in A20.
(substitute your sheet names for Jan & Dec (if your sheet names have a space
in them you'll have to use single apostraphe's around the names, e.g.
=SUM('Mth 1:Mth 12'!A20)
 
Back
Top