Unable to obtain Average due to cells contain #N/A value
I have a worksheet that I am attempting to obtain the average for Range("C1:C500"). Some cells in that range contain #N/A as a value due to a calculation for the cell (the same range being used for graphing). When I attempt to use =AVERAGE("C1:C500"), I receive #N/A as a result.
How do I obtain the average result?
Ugghhhh!
Thank you.
Why don't you do something to get rid of that #N/A error? You could use IFERROR in the cell to trap the error.
Hope this helps.
Pete
Untested
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
hi PosseJohn, try:
=SUMIF(C1:C500,"<>"&"#N/A")/COUNTIF(C1:C500,"<>"&"#N/A")
or:
=AVERAGEIF(C1:C500,"<>"&"#N/A")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you! The second suggestion resolved the conflict.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks