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

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

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

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