occurance in each year
=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
|