COUNTIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
COUNTIF Cells in Range? 4
Range Formula 7
Excel Use COUNTIF across a range of cells with formulas 0
Countif formula 2
Countif/Vlookup 2
Sorting and COUNTIF 6
countif, multiple value range PLEASE HELP 2

Back
Top