=SUMPRODUCT(--(MONTH(A1:A5)=4),--(B1:B5="y"))


"Rob Steed" wrote:

Hi,

Column A contains a list of dates in the format dd/mm/yy. In column B
each date is allocated a value of either Y or N.

What I would like to do is calculate the number of times Y and N
appears for any given month.

Any ideas hwo to implement this please?

Many thanks,

Rob.