SUMPRODUCT with LEN to sum values in rows matching a specific word

Hello all,

I am trying to sum values in a specific row of a table based on whether another column in that table includes a specific word or phrase. I have been trying to use SUMPRODUCT, with LEN and SUBSTITUTE to confirm the presence of the word within the cell.

To count/confirm the presence of the word within the cell, I've been using the following:
=LEN(A1)-LEN(SUBSTITUTE(A1),"Twitter","")/LEN("Twitter")

In the sample data, the value returned in F2 should be $590.

Grateful for any help! This is the one snag in large tracking document I am working on.

Cheers

Originally Posted by canapone

Hi All,

another attempt

=SUMIF(Table1[Tactic],"*Twitter*",Table1[Spend])

Regards

Unfortunately, this formula isn't able to pick specific words out of a string of text, so doesn't return the correct value. The previous response was able to do it! Thank you for your time and suggestion.