Formula for incremental sum with criteria

[XLalbania]

Hello Excel Friends
As you can see from this image, in D2 I need a formula copy down to Incremental SUM,
the formula would be easy =SUM($B$2:B2), but the probem is when change the name i need it to restart the SUM
Thank You For your help

	A	B	C	D
1	name	data		RESULT
2	mike	7		7
3	mike	5		12
4	mike	4		16
5	viol	17		17
6	viol	25		42
7	viol	23		65
8	viol	20		85
9	viol	7		92
10	luis	4		4
11	luis	16		20
12	jeff	11		11
13	jeff	13		24
14	jeff	25		49
15	jeff	13		62

[southward]

Hi,

Give this a try:

Please Login or Register  to view this content.

Cheers

[XLalbania]

Woow!! perfect
I was really closed but i was stuck...
Thank you your answer really heled me!

Bye

[southward]

You are very welcome. Glad I could be of some assistance.

Cheers