# Beginner's trouble with reseting sum

#### audotja

##### New Member
Hey!

I'm trying to create simple excel to use in flea market. There have been some wishes I'm trying to follow. All other problems I have solved and learned a lot by solving them, but I still have few. I have tried to find similar questions, but haven't found anything useful.

Columns A and C are left for sellers to fill in. But the column B is a problem. It is like cumulative sum, but if there are gaps, it resets. What kind of formula I need to use? Or is there any other way?

I would be really grateful for any help.

 1 A B C D 2 Price Sum Money Given Back 3 0,50 0,50 - 4 0,70 1,20 1,20 - 5 - - 6 3,00 3,00 - 7 2,50 5,50 10,00 4,50 8 - -

<tbody>
</tbody>

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### steve the fish

##### Well-known Member
Put this in B3 and copy down:

=IF(A3<>"",SUM(\$A\$3:A3),"-")

#### steve the fish

##### Well-known Member
Sorry misread. If you want it to reset the sum try something like this in B3:

=IF(A3="","-",IF(A2="",A3,B2+A3))

#### audotja

##### New Member
Thank you, I was able to get it work!

Replies
7
Views
112
Replies
4
Views
68
Replies
4
Views
96
Replies
7
Views
133
Replies
9
Views
89