I need to create a formula that will subtotal a $ amount
based on an ID#... I have tried the "subtotal feature
built into excel, but it is far too distorting and
disruptive to my spreadsheet.

What I am wanting is a formula that will give a subtotal
in a 3rd column...

EXAMPLE:

Column (A) is an ID#.
Column (B) is a $ amount.
Column (C) is my subtotal formula.

This will be sorted by column (A).

(A1)= 1 (A2)= 1 (A3)= 2

(B1)= 4.45 (B2) = 1.50 (B3)= $5.25

RESULT
(C1)= 5.95 (C2) = 5.95 (C3)= $5.25