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

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.