=SUMPRODUCT(($A$1:$A$100="Delayed Redundancy")*(YEAR($B$1:$B$100)
=2009))



On 22 Maj, 13:54, 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