Determining percentage of students between certain grades
- by dunc
I have an Excel spreadsheet with the following data:
#-----------------------------------------------------------------------------------------------------------------------------------#
# Student # KS2 Grade # Target # Expected 1 # Expected 2 # Expected 3 # FSM Status # Gifted & Talented #
#-----------------------------------------------------------------------------------------------------------------------------------#
# User 1 # 4 # 6 # 7 # 5 # 6 # Y # N #
# User 2 # 3 # 5 # 5 # 4 # 4 # N # N #
# User 3 # 5 # 6 # 6 # 6 # 7 # N # N #
# User 4 # 4 # 6 # 5 # 6 # 6 # N # Y #
# User 5 # 5 # 7 # 7 # 6 # 7 # N # N #
# User 6 # 3 # 4 # 4 # 4 # 4 # N # N #
# User 7 # 3 # 4 # 5 # 3 # 4 # Y # Y #
#-----------------------------------------------------------------------------------------------------------------------------------#
What I'd like to do is determine the percentage of students with certain levels, i.e. a range of levels.
For instance, in the data above, I'd like to determine the % of all students that have a Target level of 5 - 7.
I'd then like to also expand the formula to specify % of Gifted & Talented students with a Target level of 5 - 7.
Is this possible in Excel? If so, where do I start?