Originally Posted by janiVI
try this.....
type this
=SUM(IF(YEAR(RANGEofDATES)=YEAR,1,0))
then hit Control+Shift+Enter
example
{=SUM(IF(YEAR(B3:B20)=2004,1,0))}
the Control+Shift=Enter will add { } around the formula... dont try to manually type them in
I am guessing for this to work i would need a additionnal colum consisted of only years but in the spread sheet it is in a 2004/01/01 format and i cant really change that.