Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Countif if the value falls between 2 other values
Need to count values that fall between two limits: for example
462 997 569 122 Need to count values between 300 and 600. I can do if my desired value is over or under a target, but not within a range. Any help would be greatly appreciated. Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Countif if the value falls between 2 other values
=COUNTIF(A:A,"=300")-COUNTIF(A:A,"600")
-- Regards, Peo Sjoblom "les8" wrote in message ... Need to count values that fall between two limits: for example 462 997 569 122 Need to count values between 300 and 600. I can do if my desired value is over or under a target, but not within a range. Any help would be greatly appreciated. Thanks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Countif if the value falls between 2 other values
Try
=SUMPRODUCT(--(A1:A1000=300),--(A1:A1000<=600)) Regards, Alan. "les8" wrote in message ... Need to count values that fall between two limits: for example 462 997 569 122 Need to count values between 300 and 600. I can do if my desired value is over or under a target, but not within a range. Any help would be greatly appreciated. Thanks. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Countif if the value falls between 2 other values
Thanks to both of you. It worked!
"les8" wrote: Need to count values that fall between two limits: for example 462 997 569 122 Need to count values between 300 and 600. I can do if my desired value is over or under a target, but not within a range. Any help would be greatly appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View of x-axis values | Charts and Charting in Excel | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
Countif function | Excel Worksheet Functions | |||
Using countif to see if any values are added | Excel Discussion (Misc queries) | |||
Countif between two values | Excel Worksheet Functions |