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