countif

B

Brad

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
 
P

Peo Sjoblom

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
 
Top