Hi all

I've just registered here tonight in sheer desperation!! In the table below I'm trying to find an average of the numbers in column D (Autumn 1 %) only if the box in column C (Pupil Premium) for a person is completed as 'Yes.' I.e. the average for Pupil Premium.

I hope this makes sense? It seems like a simple formula but I can't for the life of me work out how to do it.

If anyone can help me out I'd be massively grateful.


Screen Shot 2016-02-03 at 22.29.57.png