View Single Post
  #2   Report Post  
Domenic
 
Posts: n/a
Default

Try...

=COUNTIF($B1:$B251,"<=5")

Hope this helps!

In article ,
justin_vasko wrote:

i am using countIF to find values less than or equal to 5 in a range, and
my formula
=COUNTIF($B1:$B251,{<=5})
keeps generating an error, and i dont knwo why


a little help pleasE?