I have this array formula:
IF(ISNUMBER(MATCH(Summary!C12,Detailed!$AH$2:$AH$160,0)),AVERAGE(IF(Detailed!$AH$2:$AH$160=Summary!C12,IF(Detailed!$W$2:$W$160<>"",Detailed!$W$2:$W$160))),IF(F$6=8,AVERAGE(IF(Detailed!$AG$2:$AG$160=Summary!B12,IF(Detailed!$W$2:$W$160<>"",Detailed!$W2:$W160))))))
If the content in cell Summary!C12 is not in the Detailed AH, the result of the array formula is FALSE.
How to make the result "-"?
Thank you so much