ExcelBanter - Describe high/low range with CountIf (ex. count if >90 and <100

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Describe high/low range with CountIf (ex. count if >90 and <100 (https://www.excelbanter.com/excel-worksheet-functions/45994-describe-high-low-range-countif-ex-count-if-%3E90-%3C100.html)

jsky

Describe high/low range with CountIf (ex. count if >90 and <100

JE McGimpsey

One way:

=COUNTIF(A:A,"90") - COUNTIF(A:A, "=100")

Another:

=SUMPRODUCT(--(A1:A1000<90),--(A1:A1000<100))

All times are GMT +1. The time now is 02:03 AM.