Assuming you have only text values in Col A..try the below

=SUMPRODUCT(--(A1:A100="Delayed Redundancy"),--(YEAR(B1:B100)=2009))

If this post helps click Yes
---------------
Jacob Skaria


"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