Beginner's trouble with reseting sum

audotja

New Member
Joined
Sep 23, 2014
Messages
2
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.

1ABCD
2PriceSumMoney GivenBack
30,500,50-
40,701,201,20-
5--
63,003,00-
72,505,5010,004,50
8--

<tbody>
</tbody>
 

Some videos you may like

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
Joined
Oct 20, 2009
Messages
8,110
Office Version
  1. 365
Platform
  1. Windows
Put this in B3 and copy down:

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

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,110
Office Version
  1. 365
Platform
  1. Windows
Sorry misread. If you want it to reset the sum try something like this in B3:

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

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,968
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top