Hi all,
I am trying to make some analysis a little easier and wondered if you could help. On the "Analysis" tab I would like to be able to show a number and a percentage for each of the categories in column A.
So for example column E3 should work out that the number of males in the class (those who have "M" in column B on Sheet1 who are "Above Target" is 0 and 0%.
As I grow the spreadsheet I will also have a "Below" section. So for example LAP students on the Analysis tab who are "Below" target will show as 4 students and 36%
I just need help with the formula so I can grow the spreadsheet from there.
Many thanks for your help.
Bookmarks