Countif with date

[SimonHughes]

Hello,

I am using Excel 2010

I want to count the number of quotations issued based on the year in which they were issued. The date format is dd/mm/yyyy. So I need to return the number of quotes using the yyyy as the criteria.

Your help appreciated.

 

[VoG]

One way

=SUMPRODUCT(--(YEAR(A1:A10)=2011))

 

[SimonHughes]

Yes, that works just fine, many thanks.