COUNTIF
 

I want to count how many numbers in a range are less than a given value.
However, I don't want that given value to be hardcoded in the COUNTIF formula.

For example: I want this formula: =COUNTIF(P4:P1073,"=-0.0045")
to look something like: =COUNTIF(P4:P1073,"=V4")

However that second formula doesnt seem to work. Any ideas?

=COUNTIF(P4:P1073,"="&V4)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"adamcal" wrote in message
...
I want to count how many numbers in a range are less than a given value.
However, I don't want that given value to be hardcoded in the COUNTIF
formula.

For example: I want this formula: =COUNTIF(P4:P1073,"=-0.0045")
to look something like: =COUNTIF(P4:P1073,"=V4")

However that second formula doesnt seem to work. Any ideas?