Count the date
 

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

Count the date
 

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

Count the date
 

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

Count the date
 

=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