Hi,
I don't understand if you have the CPP word in one column you want to
summarize another one, but that is not what your formula is saying, if the
below doesn't work please send an example
try

=SUM(SUMIF($a$100:$f$100,{CPP, TSF, HDJ},$f$100))

"Lindsey" wrote:

I have a spreadsheet with multiple colums and I want to sum if there is a
certain word in each column. I feel like this shold be fairly easy, this is
the formula I have now. Thanks!

=sumif( $a$100:$f$100, and( CPP, TSF, HDJ), $f$100)