Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get values between 8 and 15
I am trying to get a formula that will look in column c8:c250 and will only
give me the number of occurances between two numbers. I have used the =COUNTIF(C8:C250,"<8") to determine the number of quotes in days of the month 1-7. I have used =COUNTIF(C8:C250,"21") to determine the number of quotes in days of the month 22 -31. I can't seem to figure out how to get the value for days 8 thru 14, and days 15-21. Quotes By Week Number Days 1 - 7 17 Days 8 - 14 Days 15 - 21 Days 22 - 31 47 Thank you for your help Sam |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get values between 8 and 15
Hi Sam,
Maybe, =COUNT(C8:C250)-COUNTIF(C8:C250,"<8")-COUNTIF(C8:C250,"14") HTH Martin "Sam510" wrote in message ... I am trying to get a formula that will look in column c8:c250 and will only give me the number of occurances between two numbers. I have used the =COUNTIF(C8:C250,"<8") to determine the number of quotes in days of the month 1-7. I have used =COUNTIF(C8:C250,"21") to determine the number of quotes in days of the month 22 -31. I can't seem to figure out how to get the value for days 8 thru 14, and days 15-21. Quotes By Week Number Days 1 - 7 17 Days 8 - 14 Days 15 - 21 Days 22 - 31 47 Thank you for your help Sam |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get values between 8 and 15
Try on these formula will do the trick
=COUNTIF(MyRange,{"=8"})-COUNTIF(MyRange,{"14"}) or =SUM(COUNTIF(MyRange,{"=8","14"})*{1,-1}) or =SUMPRODUCT(--(MyRange=8),--(MyRange<=14)) "Sam510" wrote: I am trying to get a formula that will look in column c8:c250 and will only give me the number of occurances between two numbers. I have used the =COUNTIF(C8:C250,"<8") to determine the number of quotes in days of the month 1-7. I have used =COUNTIF(C8:C250,"21") to determine the number of quotes in days of the month 22 -31. I can't seem to figure out how to get the value for days 8 thru 14, and days 15-21. Quotes By Week Number Days 1 - 7 17 Days 8 - 14 Days 15 - 21 Days 22 - 31 47 Thank you for your help Sam |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get values between 8 and 15
Thank you all for the replies. Got it working.
Sam "MartinW" wrote: Hi Sam, Maybe, =COUNT(C8:C250)-COUNTIF(C8:C250,"<8")-COUNTIF(C8:C250,"14") HTH Martin "Sam510" wrote in message ... I am trying to get a formula that will look in column c8:c250 and will only give me the number of occurances between two numbers. I have used the =COUNTIF(C8:C250,"<8") to determine the number of quotes in days of the month 1-7. I have used =COUNTIF(C8:C250,"21") to determine the number of quotes in days of the month 22 -31. I can't seem to figure out how to get the value for days 8 thru 14, and days 15-21. Quotes By Week Number Days 1 - 7 17 Days 8 - 14 Days 15 - 21 Days 22 - 31 47 Thank you for your help Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Zero values in formula | Excel Discussion (Misc queries) | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
Using formula values | Excel Discussion (Misc queries) |