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)