CODEWITHSUNDEEP
excelexcel-formula
Shoaib Hossain
Shoaib Hossain

Reputation: 17

Sum value if match two text in the one cell

In excel formula is it possible to sum value if match two text in the one cell. I tried to use this below formula but it is showing "0" value.

enter image description here

Upvotes: 0

Views: 47

Answers (1)

Imran Malek
Imran Malek

Reputation: 1719

Try this formula in cell D2,

=SUMPRODUCT(B2:B10,--(ISNUMBER(SEARCH($C$2,A2:A10))))

You can also add multiple conditions by adding another array in the formula

=SUMPRODUCT(B18:B100,--(ISNUMBER(SEARCH("Black",A18:A100))),--(ISNUMBER(SEARCH("Cross",A18:A100))))

B2:B10 - Contains your text

A2:A10 - Contains your values

C2 - The text that you want to find

Upvotes: 2

Related Questions