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.