I'm trying to sort through a long list of medical CPT codes with
corresponding payments. Is it possible to use the vlookup or other function
to total all the values that correspond to a certain CPT code? For examle -
I have the following list:

CPT Amt
10021 223.76
10021 240
10021 215
10021 96.74
10061 57.62
10061 15.37
11400 6
11401 49.39
11401 105.71
11403 63.5
11403 116.85

I would like to total all the amounts for the specific CPT code:

CPT Amt
10021
10021
10021
10021 775.5
10061
10061 72.99
11400 6
11401
11401 155.1
11403
11403 180.35

The list has a bout 8000 codes so I'm really looking for something that I
can just scroll down.
Thanks!