Need assistance with a formula - If then???
 

I need to determine how often a number occurs in a range of cells above and
below a certain value. The range is 71 cells. I need to know how many times
the number is above 120 and below 120. I then need to know the percentange
of the range that was above 120 and below 120.

Need assistance with a formula - If then???
 

Try this for an example
=COUNTIF(A1:A10,"120")

"Bookmdano" wrote:

I need to determine how often a number occurs in a range of cells above and
below a certain value. The range is 71 cells. I need to know how many times
the number is above 120 and below 120. I then need to know the percentange
of the range that was above 120 and below 120.

Need assistance with a formula - If then???
 

Please don't multipost. Cross-post if you must.
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
--
David Biddulph

"Bookmdano" wrote in message
...
I need to determine how often a number occurs in a range of cells above and
below a certain value. The range is 71 cells. I need to know how many
times
the number is above 120 and below 120. I then need to know the
percentange
of the range that was above 120 and below 120.

Need assistance with a formula - If then???
 

On Oct 2, 11:11 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Please don't multipost. Cross-post if you must.http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
--
David Biddulph

"Bookmdano" wrote in message

...



I need to determine how often a number occurs in a range of cells above and
below a certain value. The range is 71 cells. I need to know how many
times
the number is above 120 and below 120. I then need to know the
percentange
of the range that was above 120 and below 120.- Hide quoted text -

- Show quoted text -

TRY THIS. =(COUNTIF(B3:B25,"<120")/(COUNT(B3:B25)))