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

[jsky]

how can I use the COUNTIF formula to count only those numbers that fit
between a range like greater than 90 but less than 100.

 

[Chip Pearson]

Use two COUNTIF functions. E.g.,

=COUNTIF(A1:A10,"<100")-COUNTIF(A1:A10,"<90")



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[jsky]

Thanks Chip.
really use minus sign between them? Does that serve as an "AND"?

 

[jsky]

Chip, I figured it out. Thank you again.

Thanks Chip.
really use minus sign between them? Does that serve as an "AND"?

 

[Ron Rosenfeld]

how can I use the COUNTIF formula to count only those numbers that fit
between a range like greater than 90 but less than 100.

=COUNTIF(rng,">90") - COUNTIF(rng,">=100")


--ron

 

[Ashish Mathur]

Hi,

You may also use array formulas (Ctrl+Shift+Enter) to solve the problem

=sum(if((range>90)*(range<100),1,0))

Regards,

Ashish Mathur