Hi,

Try this

=SUMPRODUCT((A1:A25="Delayed Redundancy")*(YEAR(B1:B25)=2009))

Mike

"TORIA28" wrote:

I have the folowing set up:

A B

Delayed Redundancy 31/08/09
Delayed Redundancy 03/06/10
Employed
Employed
Delayed Redundancy 31/08/09
Employed

I need a formula that will count how many Delayed redundancies there will be
in 2009

Thank you for your help

Toria