Hi Dennis:
Your suggestion ( =COUNTIF(F342:N380;">99")-COUNTIF(F342:N380;">129"),
also worked here.
I have used your suggestion here to generate result in an array, shown
below:
<100 1
100 thru 109 0
110 thru 119 0
120 thru 129 2
130 thru 139 10
140 thru 149 1
150 thru 159 3
160 thru 169 0
170 thru 179 1
180 thru 189 3
190 thru 199 2
200 thru 209 0
210 thru 219 0
220 thru 229 0
230 thru 239 0
240 thru 249 0
250 thru 259 0
260 thru 269 0
270 thru 279 0
I need to add a couple more rows to that array, not that I expect to
reach a bowling score within the range of 280 to 300, inclusive, anytime
soon!
Thanks.
Regards,
VinceB.
On 5/20/2016 12:01 PM, Dennis E. Hamilton wrote:
There might be a more direct way, but try
=COUNTIF(D342:L380;">99")-COUNTIF(D342:L380;">129")
If you mean between 100 and 129 inclusive. Adjust as necessary.
- Dennis
