SUMIFS or other multipule criteria search

[ignitebenhaigh]

I'm trying to get a formula that does the following. If In column A the word is X, and in column B the date is X, sum column C? It's racking my brain

 

[Robert Mika]

I'm trying to get a formula that does the following. If In column A the word is X, and in column B the date is X, sum column C? It's racking my brain

Excel 03
=SUMPRODUCT(--($A$2:$A$15=E1),--($B$2:$B$15=F1),$C$2:$C$15)
Excel>03
=SUMIFS($C$2:$C$15,$A$2:$A$15,E1,$B$2:$B$15,F1)
Where E1 and F1 are your criteria(x)

 

[ignitebenhaigh]

Hi robert, i have excel-13 and that doesn't seem to work?

 

[Robert Mika]

Hi robert, i have excel-13 and that doesn't seem to work?

Could you post your data?
Please use method in my signature.