=AVERAGE(IF(D7:DC7 ="Actual", D9:DC9)), confirmed with Ctrl+Shift+Enter