Running total formula needed

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
 
F

Frank Kabel

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

in E2 enter
=IF(D2<>"",E1+D2,"")
and copy this formula down
 
R

Ragdyer

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)
 

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

Top