Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Formula Help
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2017, 05:16 PM
charlesdh charlesdh is offline Formula Help Windows 7 32bit Formula Help Office 2010 32bit
Expert
Formula Help 		 
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
  #2  
Old 04-12-2017, 07:10 PM
macropod's Avatar
macropod macropod is offline Formula Help Windows 7 64bit Formula Help Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
An average that includes "" as a number ain't going nowhere.

PS: Your link doesn't work.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-20-2017, 10:38 AM
charlesdh charlesdh is offline Formula Help Windows 7 32bit Formula Help Office 2010 32bit
Expert
Formula Help 		 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default
Sorry. The thread I posed was incorrect.
Here's the link.
https://www.excelforum.com/excel-for...-show-n-a.html

I reposted to get the link and am getting some help. But, still no answer.
Any help would be thankful.
Attached is a copy of my workbook.

Charles
Attached Files
File Type: zip WEEKLY STATS-1.zip (46.3 KB, 11 views)
Reply With Quote
  #4  
Old 04-20-2017, 11:28 AM
xor xor is offline Formula Help Windows 10 Formula Help Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Maybe like the attached.
Attached Files
File Type: xlsx WEEKLY STATS-1_2.xlsx (58.0 KB, 12 views)
Reply With Quote
  #5  
Old 04-21-2017, 11:19 AM
charlesdh charlesdh is offline Formula Help Windows 7 32bit Formula Help Office 2010 32bit
Expert
Formula Help 		 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default
xor,

Thanks for your help. I modified your formula.
The reason is if I changed the date from 2017 to 2016 I received a "Divide by 0" error.

Code:
AVERAGEIF('Weekly Stats Data '!A15:A45,L6-1,WeeklyStats[SUITABILITY RATE])
''changed to
AVERAGEIF('Weekly Stats Data '!A15:A45,L6,WeeklyStats[SUITABILITY RATE])
To me this appears to work.
Can always depend on help from this forum.

Charles

https://www.excelforum.com/excel-for...-show-n-a.html
Last edited by charlesdh; 04-21-2017 at 11:30 AM. Reason: added url for help I received.
Reply With Quote
  #6  
Old 04-21-2017, 11:51 AM
xor xor is offline Formula Help Windows 10 Formula Help Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
I wrote L6-1 because the header in the column where I entered the formula says 2016 Average and L6-1 = 2016.

I must be misunderstanding something.
Reply With Quote
  #7  
Old 04-22-2017, 11:54 AM
charlesdh charlesdh is offline Formula Help Windows 7 32bit Formula Help Office 2010 32bit
Expert
Formula Help 		 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default
Thanks, It was my error.
Thanks for your help.

Charles
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Help 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
Formula Help 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
Formula Help 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 04:05 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft