COUNTIF - RANGE

[AWOODS]

Operating System: Mac OS X 10.5 (Leopard) I HAVE A COLUMN WITH DIFFERENT PERCENTAGES. I WOULD LIKE TO HAVE IT COUNT THE ONES THAT ARE BETWEEN 89-80% FOR INSTANCE. I CAN GET IT TO DO THE ONES THAT ARE OVER 90% AND I CAN GET IT TO COUNT THE ONES LESS THAN 69% BUT THE ONES THAT ARE A RANGE I CAN'T GET.

 

[Bob Greenblatt]

Operating System: Mac OS X 10.5 (Leopard) I HAVE A COLUMN WITH DIFFERENT
PERCENTAGES. I WOULD LIKE TO HAVE IT COUNT THE ONES THAT ARE BETWEEN
89-80% FOR INSTANCE. I CAN GET IT TO DO THE ONES THAT ARE OVER 90% AND I
CAN GET IT TO COUNT THE ONES LESS THAN 69% BUT THE ONES THAT ARE A RANGE
I CAN'T GET.

First stop using upper case. It's the equivalent of shouting and is
impolite. If you get part of it to work then you just need to change the
condition to and(<89,>90).

If you would post your formula we can help.