Assuming your data is in row 1, with the value 50 in A1, you can put
this in a different row:

=COUNTIF(1:1,"<"&A1)

If the data is in column A, starting with A1, then put this in a
different column:

=COUNTIF(A:A,"<"&A1)

Hope this helps.

Pete

On Jul 30, 11:13*pm, Access Joe
wrote:
Hey everyone,

Excel 2000

I have a range of cells like so (each number is in it's own cell)
50 * 20 * 30 * 60 *90 * 30

The FIRST cell (in this case, "50") is the 'recommended value'. *What I want
to do is create a function that looks at all the other 'variable' cells (20,
30, 60....) as one whole range and checks to see if any one of them are less
than the recommended value of 50. *If so, I want to see a count of how many
'variables' were less than 50. *So in this example, I would like to see the
answer of "3", because there are three variables in that range of cells that
are less than 50.

Hope that makes sense. *Assuming it would be some kind of IF / COUNTIF, but
can't figure out how to do it.

Thanks so much!
J