[LM_NET] TECH: Excel - averages

[Frederick Muller <mullinator52@GMAIL.COM>]

This has been bugging me for several years.  Currently when I leave a cell
blank and ask Excel to calculate an average, it counts it as zero and throws
off the average.  The old Appleworks program (on Apple IIe) used to ignore
blank cells for averages.

1. Is there a setting somewhere in Excel to tell it to ignore blank cells in
averages?
2. Is there a code I can put in a cell so an average will ignore that cell
(without making an error?)

Please respond directly to me.  I will post an answer when I get it.  Thanks

-- 
Frederick Muller
Newton, NJ
My book reviews are compiled at http://www.mullersreviews.com
My book review blog is at http://MullerInTheMiddle.blogspot.com

--------------------------------------------------------------------
Please note: All LM_NET postings are protected by copyright law.
  You can prevent most e-mail filters from deleting LM_NET postings
  by adding LM_NET@LISTSERV.SYR.EDU to your e-mail address book.
To change your LM_NET status, e-mail to: listserv@listserv.syr.edu
In the message write EITHER: 1) SIGNOFF LM_NET  2) SET LM_NET NOMAIL
3) SET LM_NET MAIL  4) SET LM_NET DIGEST  * Allow for confirmation.
 * LM_NET Help & Information: http://www.eduref.org/lm_net/
 * LM_NET Archive: http://www.eduref.org/lm_net/archive/
 * EL-Announce with LM_NET Select: http://elann.biglist.com/sub/
 * LM_NET Supporters: http://www.eduref.org/lm_net/ven.html
--------------------------------------------------------------------