try
=IFERROR(IF($A14="","",if(MATCH('Executive Summary'!$H$9,$AN$3:$BG$3) -$AK$1>0,AVERAGE(OFFSET($AN14,0,MATCH('Executive Summary'!$H$9,$AN$3:$BG$3) -$AK$1,1,AK$1))),0),0)
try
=IFERROR(IF($A14="","",if(MATCH('Executive Summary'!$H$9,$AN$3:$BG$3) -$AK$1>0,AVERAGE(OFFSET($AN14,0,MATCH('Executive Summary'!$H$9,$AN$3:$BG$3) -$AK$1,1,AK$1))),0),0)
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks