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.

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.