Hi tx12345,

This worked for me:

=IF(A3=A2,"",SUM(OFFSET(B2,1-COUNTIF(A:A,A2),0,COUNTIF(A:A,A2),1)))

Someone might have a shorter solution, they usually do.

Paste this into B2 then fill it down to the bottom of your list.

You might also want to look into Excel's automatic subtotals in Help.

Ken Johnson