Continuously adding a new cell to the exisitng forumla?

[ksan1989]

Hi all,

I'm currently doing a new worksheet for work and need some help please;
Cell's A1: Commission Per Sale Cell B1 Running total of commission

I would like the running total to continuously incorporate all of the above commissions and this has to be in the column next to the new sales commission.
E.g.
Commission $5 $7 $9
Running Total $5 $12 $21

Thank you!

 

[martindwilson]

assuming a1 says commision per sale and b1 says running total
then in b2
=IF(A2="","",SUM($A$2:A2)) fill down

 

[ksan1989]

assuming a1 says commision per sale and b1 says running total
then in b2
=IF(A2="","",SUM($A$2:A2)) fill down

Thanks that's awesome!