COUNTIF

A

adamcal

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?
 
B

Bob Phillips

=COUNTIF(P4:p1073,">="&V4)


--

HTH

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