Canadian_Newb
New Member
- Joined
- Jun 30, 2011
- Messages
- 31
I have a quick question (and you all here never fail me, so thank-you for that!):
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I’m trying to run an AVERAGE formula on an array of cells that themselves run a VLOOKUP function.
<o></o>
Now, what is happening is the VLOOKUP array cells have the N/A error in them (until data is input in another sheet). I understand that the AVERAGE function will not work with N/A errors but is there any workaround for this?
<o></o>
Because when I input data in cells that transfer a number to the VLOOKUP cells, the AVERAGE cell remains N/A…and will not pull an average of the numbers inserted.
<o></o>
Is there a workaround for this?
<o></o>
My formulas (for example):
<o></o>
Cell: C5
=AVERAGE(D5:N5)
<o></o>
Cell: D5
=VLOOKUP("USERNAME",'SCORE SHEET'!B7:K18,10,FALSE)
<o></o>
Is there another formula that I can use to accomplish acquiring the average from an array of cells that may contain N/A errors?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>I’m trying to run an AVERAGE formula on an array of cells that themselves run a VLOOKUP function.
<o
></o>Now, what is happening is the VLOOKUP array cells have the N/A error in them (until data is input in another sheet). I understand that the AVERAGE function will not work with N/A errors but is there any workaround for this?
<o
></o>Because when I input data in cells that transfer a number to the VLOOKUP cells, the AVERAGE cell remains N/A…and will not pull an average of the numbers inserted.
<o
></o>Is there a workaround for this?
<o
></o>My formulas (for example):
<o
></o>Cell: C5
=AVERAGE(D5:N5)
<o
></o>Cell: D5
=VLOOKUP("USERNAME",'SCORE SHEET'!B7:K18,10,FALSE)
<o
></o>Is there another formula that I can use to accomplish acquiring the average from an array of cells that may contain N/A errors?
