Adding costs in a specific year

Hi all,

I am trying to add up a set of values if they have a specific name and are after a certain date.

Attached is a spreadsheet with a very small example. I initially tried SUMPRODUCT but couldn't get it to work out how to tell if the date is in 2008 or 2007.

Here is the example of the code I tired but the > 31/12/2007 bit doesn't work.

Please Login or Register  to view this content.

On the document I am trying to add up all costs with name a in 2008 as an example.

Any help with this would be much appreciated.

Cheers

Simon

Thanks a lot, perfect