countif function

A

Angie

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
 
K

Ken Wright

=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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Newbie Help - IF Yes No Function 0
HOW CAN I COUNT ALL THE GROUPS IN A REPORT 0
Using <= in countifs statement 1
If AND/OR funciton with multiple criteria 2
Excel Countif Function - Calculating Between Two Sets of Values 3
Finding the weighted average of text that have been given values 1
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1

Top