| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Describe high/low range with CountIf (ex. count if >90 and <100
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. |
|
#2
|
|||
|
|||
|
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" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
Thanks Chip.
really use minus sign between them? Does that serve as an "AND"? "Chip Pearson" wrote: 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" wrote in message ... 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. |
|
#4
|
|||
|
|||
|
Chip, I figured it out. Thank you again.
"jsky" wrote: Thanks Chip. really use minus sign between them? Does that serve as an "AND"? "Chip Pearson" wrote: 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" wrote in message ... 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. |
|
#5
|
|||
|
|||
|
On Sun, 18 Sep 2005 12:49:01 -0700, "jsky"
wrote: 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 |
|
#6
|
|||
|
|||
|
Hi,
You may also use array formulas (Ctrl+Shift+Enter) to solve the problem =sum(if((range90)*(range<100),1,0)) Regards, Ashish Mathur "jsky" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurances in range of cells | Excel Worksheet Functions | |||
| countif argument for 3 occurences of which 1 refers to a range | Excel Discussion (Misc queries) | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| variable range countif | Excel Worksheet Functions | |||
Hybrid Mode
