(877) 934-6198
Send your laptop to us and we will diagnose the...
Answer
what are the disadvantages?
Problem for Business and Productivity Software
Generic problem for all Business and Productivity Sof...
Excel and the AVERAGE function
By potsandpans on Dec 30, 2007
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!!!!Best Solution
posted on Dec 30, 2007
Here is one way:
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.
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.
Yes
No
This Problem Also Relates To:
HP HP Integrated Lights Out (;iLO) Advanced Pack 1 server license Upgrade Version (452141-B21)
Sony Media Software Pictures Sound Effects Series - Volumes 1 to 5 Volume License (SSDS2000)
Sony Vegas Pro 8 for PC (SVDVD8006)
Sony ACID Loops - Ugly Remnants: Volume One Volume License for PC (855309750763)
Sony American Idol Extreme Music Creator Promo/Demo License for PC (2205808)
Apple AppleWorks 6.2.4 (M8761Z/A) for Mac
Apple Mac OS X 10.4 Tiger Full Version for Mac (MA453ZA)
Popular Solutions for Business and Productivity
Questions and Unsolved Problems for Business and Productivity
Answer
Why do I keep getting a - This is not a valid Portable Document File (PDF) document. It cannot be...
(More)
Answer
I use the name of the person I am trying to build file around.
Answer
pitch bend wheel sends volume data, too, turns down my sound as I pitch down. Won't reassign!
Answer
It keeps locking up - says it can't connect to the database. I uninstalled and reinstalled - same...
(More)
Ask our Experts
Top Business and Productivity Experts
Top Computer & Laptop Repair
