formula problem!

[hhamlinwright08]

Hi all,

Hoping to get some help with this problem..

What I need is a formula for column N which automatically calculates how many of the %numbers in column N (2:22) are lesser or equal to 15% and expresses this as a percentage.

In this case answer is 76.2%.

I hope this makes sense,

Thanks!

<a href="http://tinypic.com?ref=3005pq9" target="_blank"><img src="http://i65.tinypic.com/3005pq9.jpg" border="0" alt="Image and video hosting by TinyPic"></a>

<a href="http://tinypic.com?ref=3005pq9" target="_blank"><img src="http://i65.tinypic.com/3005pq9.jpg" border="0" alt="Image and video hosting by TinyPic"></a>

 

[joeu2004]

=countif(l2:l22, "<15%") / count(l2:l22)

 

[joeu2004]

=countif(l2:l22, "<15%") / count(l2:l22)

Sorry: you said less than or equal to 15%:

=countif(L2:L22, "<=15%") / count(L2:L22)

Beware that what appears to be 15.00% might actually be greater than 15% (e.g. 15.004%) unless the values in column L are constants or they are calculations rounded to 4 decimal places (2 percentage decimal places).

 

[hhamlinwright08]

Hi, thank you very much! That works perfectly