Microsoft Excel - conditional average multiple indirects

Asked By Ewa P on 28-Aug-14 08:32 AM
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


Harry Boughen replied to Ewa P on 28-Aug-14 04:42 PM
Hello Ewa,
Is this a question or not?
Harry
Ewa P replied to Harry Boughen on 29-Aug-14 03:34 AM
no, thank you. managed to find the way to do it pretty soon afetr i posted the question, can not delete it thou, sorry
Ewa