Microsoft Office Forums

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

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,521
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,103
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,103
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 »
Thread Tools
Display Modes
Linear Mode Linear Mode


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 10:54 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