Help with a running total on multiple sheets

[Shari C]

I am new to Excel and have learned a lot recently. I have just switche
over all my home budgeting items to Excel instead of paper. I have
workbook with about 15 sheets (one for each budget category). Each shee
has a running balance in column E. I would like a column on sheet 1 t
simply add the newest running total in column E from the remainin
sheets.

I figured out how to do a running total from multiple sheets, but it i
adding all the numbers from all the E columns and not just the newes
running balance. (I hope that makes sense)

Thanks so much for you help

 

[Shari C]

Hi,

Where on each sheet is your "running total"?
Is it fixed or does it move depending on how many "transactions" ther
are in each month?

It moves down column E as I add transactions. Each page is differen
also, as some categories have more transactions than others

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[lhkittle]

I am new to Excel and have learned a lot recently. I have just switched

over all my home budgeting items to Excel instead of paper. I have a

workbook with about 15 sheets (one for each budget category). Each sheet

has a running balance in column E. I would like a column on sheet 1 to

simply add the newest running total in column E from the remaining

sheets.



I figured out how to do a running total from multiple sheets, but it is

adding all the numbers from all the E columns and not just the newest

running balance. (I hope that makes sense)



Thanks so much for you help!

Hi Shari C,

This may work for you, it returns the sum of the last values of column E from all the sheets to a CELL in sheet1.

On sheet 1 enter this formula in a cell.
=SUM(Sheet1:Sheet3!J1)

On each sheet enter this formula in cell J1.
=IFERROR(LOOKUP(2,1/(E1:E25000<>""),E1:E25000),0)

Change J1 to suit your needs & Sheet1:Sheet3! to match your first & last sheet.

Regards,
Howard