excel. updating action in 1st sheet of a workbook to each other s

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

Guest

I wish to have a cell that gives me an ongoing total ie. profit/loss total
from sheet 1 through to sheet 12 of a workbook
 
Not sure why this is in the CrashesGPFs section of the newsgroup, but
To sum across sheets, assuming the data is in the same cell, say Z1 in
each sheet and Sheet1 is the leftmost of the sheets and Sheet12 is the
rightmost then:
=SUM(Sheet1:Sheet12!Z1)

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
I can't get this to work. I will be more specific. I have a cell j36 in sheet
titled July
which is one of 12 titled through to June. This cell contains a formula
=sum(h34-d34)
This the profit/Loss for this sheet. I wish to carry this resultinto the
next sheet (August) and on through the remaining sheets so I get a running
total.
 
J36 is the month result
So suppose you want a year-to-date result in J37:

July!J37: =J36
August!J37: =J36+July!J37
Sept!J37: =J36+August!J37
etc

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
that answer is correct, adding after J37 "in each consecutive sheet". Please
realise I am a novice. I don't quite understand the solution in regard to
each line you have written. is it an entire formula for an individual sheet
or is it the 3 lines written as one in the appropriate cell in the first
sheet, in my case being July, being copied in the corresponding cell in "each
consecutive sheet", of course selecting with shift the other sheets. I have
tried various combinations of your written answer to no avail.
 
Back
Top