NEED LATE NIGHT HELP FOR ICT

[GasMaster69]

november 2010 paper 3
question 14
Even after looking at the MS, can't figure out what formula I have to use here, help from one of the mods real quick would be very much appreciated

 

[GasMaster69]

ugh nevermind, figured it out, its just using averageif and making the range absolute