How to use sumif on a column of text that contains specific letters within a string?

Hello,

I need help with a formula that would sum column B, if column A has the letters "MMM" within the cell.
For example:
Excel Sample.jpg

Any cell in Column A that contains "MMM" no matter what position within the string of text, I want to sum column B. How can that be accomplished?

Thank you.

Thank you!!

Sorry, follow up question, what if I wanted to search for cells that had "MMM" as the last letters of the string?

For example:
Last --> WEFAFMMM
Last --> ADFSEFSEFSEFMMM
Not Last -->SDFSDFMMMSEF
Last --> SEFSEFMMM

Just remove the last * from the above formula.

Please Login or Register  to view this content.