This is the formula that I am usimg to list all of the kids that scored
in the range 0-3. =SUM((E2:E26=0)*(E2:E26<=3))

For some reason it is not counting the zeros unless I create it the
following way:
=SUM((E2:E26=0.1)*(E2:E26<=3)) and then format the colum to round
down.

I may try the pivot table idea, but I was hoping to avoid that.

Thanks!!


--
Tobro88
------------------------------------------------------------------------
Tobro88's Profile: http://www.excelforum.com/member.php...o&userid=28895
View this thread: http://www.excelforum.com/showthread...hreadid=486415