This is a rather complex question to explain, I fear!

Here's the sample data I'm working with:

What I'm trying to do is this:

Count the number of `Gold Gifted`

students (i.e. where column `G`

has a value of `Y`

) that ALSO have a `KS4 TARGET`

(column `I`

) value of `A`

or `A*`

.

So, for instance, if the list has **5 Gold Gifted students**, but only **4** of those students have a **target grade of A* or A**, the value I would want displayed is **4**.

I'm not even sure where to start. I've tried the following formula but I'm not sure I'm even on the right lines:

`=SUM(('Student Breakdown'!$G$10:$G$272="Y")*('Student Breakdown'!$I$10:$I$272="A*")*('Student Breakdown'!$I$10:$I$272="A"))`

Can anyone help? Thanks in advance,