What kind of formulae would I use if I need to average figures from a list but ONLY if they fulfill another criteria? I have attached a picture of a very simple version of a much, much bigger spreadsheet to illustrate what I am trying to do. Other people will be adding more children now and again and I want the formulae to be able to search for a criteria so that the others don't have to change the formulae as they have even less idea what they are doing to me!
So where I have put "???" in red, I want the formulae to average the Year 1 Autumn mark from the data immediately above but ONLY if the data is from a boy, which can been seen from the letter B or G in the gender column next to the names.
I'm the only person in school with any idea of how to use excel even at a simple level and this is doing my head in! My15yo DD has just told me to ask the hive mind since just googling an answer comes up with some very confusing answers! Your help would be very much appreciated!
Please or to access all these features
Please
or
to access all these features
Geeky stuff
Help desperately needed, excel formulae!
11 replies
Feelingworriednow · 20/04/2017 11:10
OP posts:
Please create an account
To comment on this thread you need to create a Mumsnet account.