Formula Help

		Microsoft Office Forums > Microsoft Excel > Excel
Formula Help

04-12-2017, 05:16 PM

charlesdh

Windows 7 32bit Formula Help

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Can you help me with this formula?	mikey1984	Excel	5	07-01-2016 06:44 AM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Formula help	furface00	Excel	10	02-26-2012 05:34 AM
Help with formula please.	AndrewSE	Excel	3	04-05-2011 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:30 AM.