Hi,
please ignore: its sorted now :)
=IF($F$3<>"",AVERAGEIFS(LevelsGCSE!$RH$3:$RH$274,INDIRECT($O$5),"<>""",LevelsGCSE!$D$3:$D$274,"<>""",INDIRECT($G$7),$F$7),
IF($F$3<>"",AVERAGEIFS(LevelsGCSE!$RH$3:$RH$274,INDIRECT($O$5),"<>""",LevelsGCSE!$D$3:$D$274,"<>""",INDIRECT($H$7),$F$3),AVERAGEIFS(LevelsGCSE!$RH$3:$RH$274,INDIRECT($O$5),"<>""",LevelsGCSE!$D$3:$D$274,"<>""")))
old post:
I'm not even sure how to even describe the problem and I can not upload the file :(.
I need to average values from column RH on another sheet (indirect($o5$), the average needs to be based on if formula (if value in column indirected by G7 match values cell f7 and in column D3:D274 are not blank.
it would be something like that but i cna nto get it to work :(
| AVERAGEIFS(INDIRECT($O$5),(INDIRECT($G$7)=$F$7)(LevelsGCSE!$D$3:$D$274<>"") |
Thank you
Ewa