Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF Cells in Range?
I have a column of numbers (93, 96, 97, 76, 87, 97, 100, etc.) I need a
formula that will populate how many cells have numbers falling between 65-75, another formula showing cells between 76-89. Just for clarification, this is not a SUM of the data. It is a count of cells that fall between a given range. Displaying the number of cells below 65 was easy (=COUNTIF(C4:C29,"<=65")). Displaying the number of cells 90 and above (=COUNTIF(C4:C29,"=89")). It's the ranges in between that have me stumped. I know this is not the formula, but what I need is =COUNTIF(C4:C29,"cells with numbers between 65 and 75") I am sure this is easy, but I cannot seem to find it. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF Cells in Range?
65 and below: =COUNTIF(C4:C29,"<=65")
Above 65 to 75: =COUNTIF(C4:C29,"<=75")-COUNTIF(C4:C29,"<=65") Above 75 to 90: =COUNTIF(C4:C29,"<=90")-COUNTIF(C4:C29,"<=75") Above 90: =COUNTIF(C4:C29,"90") Regards, Fred "Joe" wrote in message ... I have a column of numbers (93, 96, 97, 76, 87, 97, 100, etc.) I need a formula that will populate how many cells have numbers falling between 65-75, another formula showing cells between 76-89. Just for clarification, this is not a SUM of the data. It is a count of cells that fall between a given range. Displaying the number of cells below 65 was easy (=COUNTIF(C4:C29,"<=65")). Displaying the number of cells 90 and above (=COUNTIF(C4:C29,"=89")). It's the ranges in between that have me stumped. I know this is not the formula, but what I need is =COUNTIF(C4:C29,"cells with numbers between 65 and 75") I am sure this is easy, but I cannot seem to find it. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF Cells in Range?
Another one...
List these bin levels: E4 = 65 E5 = 75 E6 = 90 E7 = 90+ Select the range F4:F7 Array enter** : =FREQUENCY(C4:C29,E4:E6) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. Or, you can setup a histogram which will do the same thing as above without having to enter a formula. ToolsData AnalysisHistogram -- Biff Microsoft Excel MVP "Fred Smith" wrote in message ... 65 and below: =COUNTIF(C4:C29,"<=65") Above 65 to 75: =COUNTIF(C4:C29,"<=75")-COUNTIF(C4:C29,"<=65") Above 75 to 90: =COUNTIF(C4:C29,"<=90")-COUNTIF(C4:C29,"<=75") Above 90: =COUNTIF(C4:C29,"90") Regards, Fred "Joe" wrote in message ... I have a column of numbers (93, 96, 97, 76, 87, 97, 100, etc.) I need a formula that will populate how many cells have numbers falling between 65-75, another formula showing cells between 76-89. Just for clarification, this is not a SUM of the data. It is a count of cells that fall between a given range. Displaying the number of cells below 65 was easy (=COUNTIF(C4:C29,"<=65")). Displaying the number of cells 90 and above (=COUNTIF(C4:C29,"=89")). It's the ranges in between that have me stumped. I know this is not the formula, but what I need is =COUNTIF(C4:C29,"cells with numbers between 65 and 75") I am sure this is easy, but I cannot seem to find it. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF Cells in Range?
Thanks Fred and T. That did the trick!
Joe |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF Cells in Range?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Joe" wrote in message ... Thanks Fred and T. That did the trick! Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif over a range of cells for various codes. | Excel Worksheet Functions | |||
Countif skips cells in range | Excel Discussion (Misc queries) | |||
COUNTIF absolute value of cells in a range are 0 | Excel Discussion (Misc queries) | |||
COUNTIF in a range (and parts of cells) | Excel Worksheet Functions | |||
using countif in isolated cells not a range | Excel Worksheet Functions |