Count If Function
What do you mean by "between"? If the 25 and 40 are to be excluded...
=COUNTIF(A1,"<40")-COUNTIF(A1,"<=25")
If they are to be included...
=COUNTIF(A1,"<=40")-COUNTIF(A1,"<25")
Note the different "<", "<=", "" and "=".
Rick
"benny" wrote in message
...
Is there a way to use the Count if function to count if a value is between
25
and 40?
Using Excel 2003
|