|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 7th, 2005, 07:59 PM
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
December 7th, 2005, 08:07 PM
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
December 7th, 2005, 08:11 PM
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
December 7th, 2005, 09:58 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Keeping a cell value constant trhoughout a list of values | borikua05 | Worksheet Functions | 2 | December 3rd, 2005 03:03 PM |
| Updating fields... | NWO | Database Design | 8 | October 28th, 2005 08:40 AM |
| How can I break values apart that are in the same cell? | Phil | Worksheet Functions | 3 | October 4th, 2005 03:41 PM |
| default values in queries | Jeff B | Running & Setting Up Queries | 11 | March 3rd, 2005 12:49 AM |
| average, eliminating zero values | Chris | Worksheet Functions | 6 | May 14th, 2004 11:36 PM |
Linear Mode
