If you want to use countif for this, you'll have to use something like;
=COUNTIF(A1:A10,"=95")-COUNTIF(A1:A10,"100")
Watch the and = signs of course to make sure they fit ur needs.
"Ronbo" wrote in message
...
How do I get Countif to count the number of occurrences between 95 and
100?
Thanks
|