EASY ONE ! using countIF.. puzzled

[Guest]

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?

 

[Domenic]

Try...

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

Hope this helps!

 

[Guest]

sorry, i got that working, but also i need to incorporate an "AND" into my
countIF, whereas the value desired is >0 and <=5,

just a little clarification

 

[Guest]

yea, 5 min after i posted i got that working, but... do u know how to
incorporate an AND into it, so i could have >0 and <=5 for the same count
if?

thanks for your help!

 

[Guest]

=COUNTIF($B$1:$B$251,"<=5")-COUNTIF($B$1:$B$251,"<=0")

Vaya con Dios,
Chuck, CABGx3