Sumif Or Sumproduct?

[djfatboyfats]

I Need help on a formula, example below

18/08/2006 £100 Postdated
18/08/2006 £100 Postdated
18/08/2006 £100 Postdated

I need a fomula that will look for 3 columns it will lok for critiria "18/08/2006" and "Postdated" and give me the answer of £100, i only want to get this answer if both the criteria match

Please i need help ASAP

Thanks you very much

DJ

[Excelenator]

Assuming your data is in Cols A,B,C and rows 1,2,3


SUMPRODUCT((A1:A3=18/08/2006)*(C1:C3="Postdated")*(B1:B3))