How do I tell excel to average a column of numbers AND ignore any zero values?
Comments:
Dec 30, 2007
- 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!!!!
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.
Why do I keep getting a - This is not a valid Portable Document File (PDF) document. It cannot be...
(More)
Why do I keep getting a - This is not a valid Portable Document File (PDF) document. It cannot be opened. Error... even if I am creating a new document. It won't let me do anything! I am using Photoshop Elements 6.0 Mac
It keeps locking up - says it can't connect to the database. I uninstalled and reinstalled - same...
(More)
It keeps locking up - says it can't connect to the database. I uninstalled and reinstalled - same problem.