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
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

ra-ke

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.

Hi,

 

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

 

http://wikisend.com/download/591416/averageif.xls

 

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