hello again,

i have two reference columns A & B
column A contains text, column B contains numbers

i also have another two columns C & D
column C contains text, column D contains the sum formula i am looking for.

C look-up for A, only for the 2 digit prefix.

while D sums up for B

e.g
A B C D
12 5 12 21
12A 10 13 54
12B 5
12C 1
13 6
13.01 3
13.02 45

If theres a formula available for Column D, please share.

--
regards,