Thank you Mike, it does not work. I am displaying this results on another
sheet.

"Mike H" wrote:

Hi,

This assumes your dates are in Column A and France is in column B

=SUMPRODUCT((B1:B20="France")*(YEAR(A1:A20)=2004))

Mike

"Noha" wrote:

hello everybody, I am using Excel 2003 and have a database of participants
(country, meeting, year, male or female), please help me in finding a
function that sums the number of times that a word (ex. France) appears in a
column "Country" during (ex. 2004) in column "year".

Thank you