Count the date

[TORIA28]

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

 

[Mike H]

Hi,

Try this

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

Mike

 

[Jacob Skaria]

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

 

[Jarek Kujawa]

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