That actually fixed the problem. Thank you very much. Would you mind
quickly explaining why this works and why the other method doesn't work?
Thanks!

kris


"keepitcool" wrote in message
...
try:

=SUM(N(A1:A100="1.1"))
entered as array (ctrl-shift-enter)

keepITcool