[LM_NET] TECH: Excel average - oops

[Frederick Muller <mullinator52@GMAIL.COM>]

Sorry for the question, I saw my error.  I was averaging a column which had
a calculation.

I did get the following response which may be of help to some of you

I believe you're using AVERAGEA instead of AVERAGE in your formula. When
using AVERAGEA, empty text is referred to as a '0'. When using AVERAGE,
empty cells are ignored. Hope this helps.

-- 
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
--------------------------------------------------------------------