countif
 

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



"Brad" wrote:

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

Thank you

"Brad" wrote:

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