Hi thanks for the reply

Can we have sum using char(10) as below?

if multiple names with multiple values

column C column D
RB3043 7.5
Pearl15 1
BR715 1

or

if same name with multiple values


RB3043 290.75 (this is comes from three places)

Please advise