=AVERAGE(IF(D7:DC7 ="Actual", D9:DC9)), confirmed with Ctrl+Shift+Enter
=AVERAGE(IF(D7:DC7 ="Actual", D9:DC9)), confirmed with Ctrl+Shift+Enter
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks