% within specified range

[nutritiouspig]

i know it's something simple that im missing. i have data in column C:C. I need to determine what % of that data is within the range of 275-320

thanks!!

 

[Scott Huish]

Give this a try:

=SUMPRODUCT(--(C1:C1000>=275),--(C1:C1000<=320))/COUNT(C1:C1000)

 

[nutritiouspig]

that worked. thanks... i would never of thought to use sumproduct either... i love that function more and more!

 

[Tazguy37]

=SUMPRODUCT(--($C$1:$C$1000>=275),--($C$1:$C$1000<=320))/COUNTA($C$1:$C$1000)*100

Make sure all your ranges are the same size. *Stupid slow "T3"