Counting number of instances of different scores in a filtered list
Posted on 2014-11-23
I need to produce some graphs showing the distribution of scores for different groups.
There are about 2000 people. Each person is scored on a scale 1 to 6. There are about 10 different groups.
I want to produce a graph for each group showing the distribution of scores in percentages.
If I use the COUNTIF function it counts all the items, whether filtered or not, so this doesn't work. At the moment the only workaround I can think of is to sort the list by group then copy the data for each group to a different worksheet.
Any suggestions how I can do this more elegantly please?
I have Excel 2010