EASY ONE ! using countIF.. puzzled
 

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?

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?

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

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!

"Domenic" wrote:

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?

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

Vaya con Dios,
Chuck, CABGx3



"justin_vasko" wrote:

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