Running total formula needed

  • Thread starter Thread starter Gadgetman
  • Start date Start date
G

Gadgetman

I am typing in a list of figures (£.p) in Column D.

What formula would I need to write, so that in each cell in Column
next to each entry I type in Column D, I would have displayed
running total.

EXAMPLE:

D E
£3.00 £3.00
£4.00 £7.00
£4.00 £11.00
£6.00 £17.00
£5.50 £22.50

Thank
 
Hi
in E1 enter
=IF(D1<>"",D1,"")

in E2 enter
=IF(D2<>"",E1+D2,"")
and copy this formula down
 
If there is the possibility of column D having empty cells, try this formula
in E1, and copy down as needed:

=SUM($D$1:D1)
 
Back
Top