Function recognizes two columns and adds total of two other columns

I currently have a function that I have been using for awhile that recognizes words in column A (Keywords) and once it matches up these exact words, will then add the sum of columns C (Clicks) and Column D (cost) together for each individual word.

The function looks like this for column C: =SUMPRODUCT(--(A$2:A$1489=A2)*(C$2:C$1489))

and this for Column D: =SUMPRODUCT(--(A$2:A$1489=A2)*(D$2:D$1489))

BUT now I need the function to recognize two columns, instead of one. Column A (Keywords) and Column B (Match Type) and give me the total Clicks and Total Costs for each one.

So basically, the function must have a match for a word in column A and a word for Column B. Once there is a match on BOTH columns, then the function can add the sum of Column C (Clicks) and Column D (Cost) for that particular keyword/match type.

Should be able to take the function provided above and just add one more function type to it, but I don't know enough on functions to do this. Please help.

ok...thanks for the page, but this is a very long page and I am not an excel master so some of it is quite foreign to me. Can you point at which section pertains to my query or just simply send me the function?

Thank you.

Hi

1) On the link the second last formula in the Evolving Use of Sumproduct refers [=SUMPRODUCT((A1:A10="Ford")*(B1:B10="June")*(C1:C10))]

2) Your first formula above would be changed to
column C: =SUMPRODUCT(--(A$2:A$1489=A2),--(B$2:B$1489=B2),(C$2:C$1489))


rylo

Thank you VERY much Rylo for your help. That is just what the doctor ordered!