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?

**UPDATE**: I've attempted my own formula.

I've created three formulas in separate cells:

`=COUNT('Student Data'!AB2:AB19)`

<-- count the number of cells containing values.

`=SUMPRODUCT(('Student Data'!AB2:AB19 >= 6)*('Student Data'!AB2:AB19<=7))`

<-- work out how many of the values in that data range are between levels 6 and 7.

`=SUM(E25/D25)`

<-- work out the percentage of students from SUMPRODUCT formula.

**This appears to work, however...** I'm not sure how to amend these formulas for, for example, `Gifted & Talented`

students.

I'd then like to also expand the formula to specify % of Gifted & Talented students with a Target level of 5 - 7.