Excel formula

I need to tally a column, but need to have two other columns return a true value when it recognizes certain text in a fourth column.  And sum that first column.   I can use SUM, but that only finds...