c1: =LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&1234567 890))-1)
copy down to c6

d1: =SUMPRODUCT((C1:C6={"X","XA","XXA"})*B1:B6)


"PERANISH" wrote:

I having some datas in one column 9n many rows. i want to take reference in
some letters fot SUMPRODUCT FUNCTION

EXAMPLE

COL-A COL-B
XA10010253 5
XXXA10012267 1
XA20045682 2
XXXA23564457 4
XAA1000253 1
XAA200000 3

I WANT FORMULA IF COL-A CONTAINS - X - SUM COL-B
LIKE, IF COL-A CONTAINS - XA - SUM COL-B
LIKE, IF COL-A CONTAINS - XXA - SUM COL-B

WHETHER I CAN USE WITH SUMPRODUCT FUNCTION.

AWAITING YOUR HELP PLEASE.
THANKS
PERANISH