Pantelis, I thought you had dates like 1-1-1990 in the column, if you just
have the year use one of the countif formulas that Dan gave you
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Paul B" wrote in message
...
Pantelis, try this =SUMPRODUCT((YEAR(A1:A100)=1990)*(B1:B100))

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"pantelis" wrote in message
...
Hi all,

Got a bit of a problem, I want to use the sumif comand as a countif i.e.
I
have data with years 1990 to 2003 in column A and in column B I have
various
numbers.

I want with a comand similar to sumif to show show me how many of the
1990
years make up the 1990 total.

Would appreciate your help.

Pantelis