=SUMPRODUCT(--(YEAR(K2:K850)=2007))
I entered the above formula, and receive a value error. I went back and made
sure the dates wer formatted as date, and received hte same error. The dates
are entered as 01/05/2007

did I not copy the formula correctly

All the best,
Dick

"Duke Carey" wrote:

Try

=SUMPRODUCT(--(YEAR(K2:K850)=2007))


"Anvil22" wrote:

I have a 850 dates in a column with various years. I want to count the number
of occurances in each year. I use the following formula but continue to
reveiw 0. The formula I am using is;
=COUNTIF(k2:k850,"(date(2007/1/1)=(date(2007/12/31)")

What I am lookin for is the number of entries in 2007.
Can anyone tell me what I am doin wrong/
Thanks
Dick