I have a spreadsheet where I want to sum the costs based upon a code that
they posses and the date in which the costs are processed.

My spreadsheet looks like this:-

B C D E
F
CODE DATE DESCRIPTION ORDER NO. COST
CS01 14-Aug-08
£10,000
CS02 14-Aug-08
£500
CS01 14-Aug-08
£10,000

I have the formula:

=SUMPRODUCT(--(B2:B4="CS01"),--(C2:C4=DATE(2008,8,14)),(F2:F4)

When I input this formula I recieve a #VALUE? Is there anything that I am
doing wrong?