how do I compare occurances of countif of two values

S

Sea Jay

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
 
B

Bob Phillips

I guess you mean

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

assuming A2:A100 holds dates
 
Top