countif

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

Guest

is there anyway to reference a cell as part of the criteria in countif
=COUNTIF(F4:Z4,"<.00202") = returns a value of 6
=COUNTIF(F4:Z4,"<a4") = returns a value of zero - even though +a4=.00202 - I
believe that it is looking for the characters <a4 - rather than using this as
a cell reference
 
Wow! Third question today about this topic
Use an ampersand

=COUNTIF(F4:Z4,"<"&A4)

will work, otherwise it will look for the
text string "A4"


Regards,

Peo Sjoblom
 

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
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
SUMIF? 9
Counting with multiple matching criteria 11
Please help!! Countif formula doesnn't work with text format 5
Counting Problem 2
Countifs anchoring formula when sorting 1

Back
Top