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

Hi!

What's wrong with countif?

To use a cell ref:

=COUNTIF($B$3:$B$40,"<"&A1)

Biff

-----Original Message-----
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


.