How do I Countif for a range of values
Elegant ! Thanks very much.
"bpeltzer" wrote:
If it's a continuous range so as [5,10), you can get there by counting those
five or greater and subtracting the count of those greater than or equal to
10:
=countif(a1:a30,"=5")-countif(a1:a30,"=10")
|