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.49.57.png
Bookmarks