Just wondering if anyone can help me with this...
I've got a spreadsheet of test results which I now need to 'count'.
It shows test scores for each child (marks out of 20) for 20 different tests. What I need to do is total up how many times each child obtained a score within a certain range. The ranges are a)0-7, b)8-14, c)15-20. I have managed to use the 'countif' function for the first and last group, by using '<8' and '>14'. However the middle group seems impossible to count.
How do I ask excel to total the number of occasions on which a test score of 8,9,10,11,12,13 or 14 was obtained? I've tried looking in the help menu, but not being very good with geek-speak, it hasn't really helped much. I'm assuming it is possible to do this with excel?
Also, although 'countif' works for the majority of the childrens' results, it doesn't work for every one, and sometimes I'm left with an error message. I've looked at the cells, but nothing seems amiss.
Any ideas?
