Beginner's trouble with reseting sum

[audotja]

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>

 

[steve the fish]

Put this in B3 and copy down:

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

 

[steve the fish]

Sorry misread. If you want it to reset the sum try something like this in B3:

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

 

[audotja]

Thank you, I was able to get it work!