How do I eliminate zeros from my Excel database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Formula Help 2
How do I eliminate zeros from my Excel database? 2
How to eliminate 0's 3
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Omitting Zero's in Formula's 3
how to convert numbers and delete leading zeros 18
Calculating STDEV for non zeroes 1
Access My Expression Contains Wrong number of arguments 0

Back
Top