COUNTIF:hardcoded

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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>