At first I thought that this solution would work only if SUMMING up numbers and not AVERAGE. I tried average but it didn't work. I then typed the formula exactly as posted (substituting my range) and it worked like a charm. THANK YOU VERY MUCH!!!!At first I thought that this solution would work only if SUMMING up numbers and not AVERAGE. I tried average but it didn't work. I then typed the formula exactly as posted (substituting my range) and it worked like a charm. THANK YOU VERY MUCH!!!!
You can't post conmments that contain an email address.
In this example, my numbers are in cells a1 through a4. My average is computed with the formula:
=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")
I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
At first I thought that this solution would work only if SUMMING up numbers and not AVERAGE. I tried average but it didn't work. I then typed the formula exactly as posted (substituting my range) and it worked like a charm. THANK YOU VERY MUCH!!!!
×