Evening,
I am trying to use the following formula
=AVERAGEIFS(KS3WRii!H$2:H$9999,KS3WRii!C$2:C$9999,"Year 7",KS3WRii!F$2:F$9999<>"White - British")
There appears to be something wrong at with the last argument where it is only checking if White - British is not in the column F.
Thanks for any advice you can give.
Regards
Bookmarks