Question about Computers & Internet
How do I tell excel to average a column of numbers AND ignore any zero values?
Here is one way:
In this example, my numbers are in cells a1 through a4. My average is computed with the formula:
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.
Posted on Dec 30, 2007
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Sep 19, 2017 | Excel Computers & Internet
Sep 16, 2015 | Microsoft Office Excel 2007
Feb 18, 2015 | Microsoft Excel for PC
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...
Aug 26, 2009 | Microsoft Office Excel 2007
Mar 10, 2009 | Microsoft Excel for PC
Sep 30, 2008 | Microsoft Excel for PC
Apr 04, 2008 | Microsoft Excel for PC
Sep 18, 2018 | Ultra Computers & Internet
Sep 18, 2018 | Computers & Internet
317 people viewed this question
Usually answered in minutes!