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)))