One way:

D2: =SUMIF($A$2:A2,A2,$C$2:C2)

Copy down as far as necessary.


In article ,
"RockyMountains" wrote:

I have data as follows: I would like to create a formula that gives me a
cumulative balance by owner by date -- How do I do that? Thanks.
Owner Date Amount
1 01/01/90 100.00
1 02/01/90 -50.00
1 03/01/90 -25.00
2 01/01/90 50.00
2 02/01/90 75.00