Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I eliminate zeros from my Excel database?
I would like to average a good deal of data from my database, but do not know
how to eliminate the zeros so they are not factored into my calculations. I would greatly appreciate any help on this! Thank you. |
#2
|
|||
|
|||
Use an array formula like the following:
=AVERAGE(IF(A1:A10<0,A1:A10,FALSE)) Change the ranges to suit. Since this is an array formula, you must press CTRL+SHIFT+ENTER rather than just ENTER the first time you enter the formula and whenever you edit it later. If you do this properly, Excel will display the formula enclosed in curly braces {}. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "HDOTM" wrote in message ... I would like to average a good deal of data from my database, but do not know how to eliminate the zeros so they are not factored into my calculations. I would greatly appreciate any help on this! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Query a Access database that has a module from Excel | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |