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
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,