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.
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" <[email protected]> wrote in message
news:[email protected]...
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks