| 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 | |||
Linear Mode
