The circular reference is in AK14
=IFERROR(IF($A14="","",AVERAGE(OFFSET($AN14,0,MATC H('Executive Summary'!$H$9,$AN$3:$BG$3) -$AK$1,1,AK$1))),0)
The circular reference is in AK14
=IFERROR(IF($A14="","",AVERAGE(OFFSET($AN14,0,MATC H('Executive Summary'!$H$9,$AN$3:$BG$3) -$AK$1,1,AK$1))),0)
Posting Permissions
Reply With Quote
Bookmarks