Sum column B until column A text changes

[labogola]

I have two columns. Column A & Column B. Column A is either "buy" or "sell." Column B is some arbitrary number.

I want to sum column B until Column A changes its value.

E.g.

A B
Buy 5
Buy 1
Buy 4
Sell 3
Buy 2
Sell 4
Sell 4


Should become

A B
Buy 10
Sell 3
Buy 2
Sell 8

I'm going to build it out to something more complex later which includes multiple columns but it's all based on this idea of doing some operation until the Column value changes.

Any suggestions or ideas?

[Phuocam]

Try

[Akuini]

Try this:

Please Login or Register  to view this content.

The Result:

Excel 2013 32 bit

	A	B	C	D	E
1	Buy	5		Buy	10
2	Buy	1		Sell	3
3	Buy	4		Buy	2
4	Sell	3		Sell	8
5	Buy	2
6	Sell	4
7	Sell	4

Sheet: Sheet2