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 values in one column.  Trying IF AND, but I keep getting an error and cant figure it out.

More detail. I am pulling transactions from a Credit Card.  I want to categorize some as ADVERTISING. Another columns will be designated DIRECT. So, I want the formula to run through the range of cells and where it sees ADVERTISING, AND the range of cells that has DIRECT and add up the totals in the column with the charges.