How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds


Customer Question

when averaging a column of numbers, it will show N/A's, it will not average. i have to go in and manually eliminate the n/s's. what do you tell it to let it average? thanks
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  John D replied 5 years ago.



What is the range that you are trying to average?




Customer: replied 5 years ago.
let's say t5:t44
Expert:  John D replied 5 years ago.

Ok here is the formula for that


the formula is in the yellow cell


Please note that this formula is an 'array formulas' which must be entered by pressing Ctrl + Shift +Enter keys (instead of just the Enter key). If you do it correctly Excel will automatically place curly brackets around the formula { }. When you edit the formula you must confirm with Ctrl+Shift+Enter


Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

Expert:  John D replied 5 years ago.

Was it ok?



Customer: replied 5 years ago.
no, i need explicit steps, do this now, then do that, etc until the end.
Expert:  John D replied 5 years ago.

hmm.. that is not what you asked for originally. No problem go ahead and click accept if the formula worked while I prepare the explanation



Customer: replied 5 years ago.
i want to be able to average a column (anywhere from 15-35 numbers) that contain N/S's. I want an average, so i won't have to manually delete each n/a.
Expert:  John D replied 5 years ago.

Sure when I accept I will be happy to continue (you have 3 unaccepted answers)



Customer: replied 5 years ago.
so, i will go elsewhere
Expert:  John D replied 5 years ago.
It's up to you. You know you what you need to do in order to continue here

Related Microsoft Office Questions