COUNTIF function
Attempting to determine class intervals. I have used
the Data Analysis, Histogram tool but the criteria
is not correct. I want upper class intervals to be
"less than" something rather than lower class intervals
to be "greater than" something.
Tried this, which works, but is there a better way?
Notice that I have a value rather than a cell reference
in the criteria, I could not get it to work when I used
a cell reference.
=COUNTIF($B$3:$B$40,"<120")
=COUNTIF($B$3:$B$40,"<240")-$E$6
=COUNTIF($B$3:$B$40,"<360")-($E$6+$E$7)
=COUNTIF($B$3:$B$40,"<480")-($E$6+$E$7+$E$8)
Suggestions welcomed, thanks,
Les
|