View Single Post
  #2   Report Post  
Dave R.
 
Posts: n/a
Default

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