Another way

=SUMIF(A1:A7,"12*",B1:B7)+SUMIF(A1:A7,12,B1:B7)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"driller" wrote in message
...
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,