How to sumif with a particular word

[jack999]

how to use formula for summing the follow with the word that contain 15w b22 in the cells

Item	Qty	Sum	Total
15w b22 cdl ball	15​	15w b22
15w b22 ww	25​
15w b22 ww re	15​
15w b22 prpk	10​
15w b22 4star	8​

thanks

 

[rahulshewale1]

Hii,

Try below formula

=Sumifs (sum-range , crateria range , "*"&"15w b22"&"*")

 

[Hui]

=SUMPRODUCT((LEFT(A2:A11,LEN(C2))=C2)*(B2:B11))

 

[bosco_yip]

Or…............

=SUMIF(A:A,C2&"*",B:B)

Regards

 

[jack999]

thanks for all