Thread: countif
View Single Post
  #3   Report Post  
Brad
 
Posts: n/a
Default

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