If I change one of my sample dates to a non-date text entry up pops a #VALUE
error. This, and the way you showed the dates in the criteria for your
original post suggests that you have text entries that look like dates to you
but that Excel can't translate.

I'd suggest you test the formula on a small subset of data that you now to
be date values (if you reformat the cell to General and the value in the cell
doesn't change appearance, it's not a date)


"Anvil22" wrote:

=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