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