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?