how do I compare occurances of countif of two values
 

How do I use Greater than and less than operators in conjuction with a
formatted cell using year 'yy' to count two particular ages age brakets
the help formuala uses a - sign and this appears to subtract the two countif
statement products

I guess you mean

=SUMPRODUCT(--(YEAR(A2:A100=2000)),--(YEAR(A2:A100<=2002)))

assuming A2:A100 holds dates

--
HTH

Bob Phillips

"Sea Jay" wrote in message
...
How do I use Greater than and less than operators in conjuction with a
formatted cell using year 'yy' to count two particular ages age brakets
the help formuala uses a - sign and this appears to subtract the two
countif
statement products