countif function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi, i need to put .5<3.5 in the criteria of the countif function but i don't think you can do that, as the value i get is always 0..whereas if i put <3.5...it returns with the correct value...is there another function i can use that will let me count the no. of times data appears that is .5<3.5
thanks
 
=COUNTIF(A1:A100,"<3.5")-COUNTIF(A1:A100,"<=0.5")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Angie said:
hi, i need to put .5<3.5 in the criteria of the countif function but i don't
Click to expand...
think you can do that, as the value i get is always 0..whereas if i put
<3.5...it returns with the correct value...is there another function i can use
that will let me count the no. of times data appears that is .5<3.5?
 
Back
Top