Thread: Formula Help
View Single Post
 
Old 04-12-2017, 05:16 PM
charlesdh charlesdh is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default Formula Help
Hi,

I'm trying to use this formula
Quote:
AVERAGE(INDEX(WeeklyStats[SUITABILITY RATE], MATCH(Mock!$L$6,WeeklyStats[YEAR],0)),"")
.

I get a "N/A" error. Can someone tell me where I went wrong?

I'm not a formula person. But, trying to help a friend

Charles
https://www.excelforum.com/newthread...postthread&f=8
Last edited by charlesdh; 04-12-2017 at 06:11 PM. Reason: Posted to another site
Reply With Quote