S
Sam510
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
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