software

I am trying to average a range of cells which sometimes includes blank
cells, which returns: #DIV/0! This happens when the entire range is
blank, but works fine when data is present. I would also like for it
to display quot;NOquot; instead of #DIV/0!

The formula I used was: =AVERAGE(B4:M4)

Any help is much appreciated!--
Areaka
------------------------------------------------------------------------
Areaka's Profile: www.excelforum.com/member.php...oamp;userid=33426
View this thread: www.excelforum.com/showthread...hreadid=532426
Areaka,

=IF(ISERROR(AVERAGE(B4:M4)),quot;NOquot;,AVERAGE(B4:M4))

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=532426one mo

=if(count(b4:m4)=0,quot;NOquot;,average(b4:m4))
Areaka wrote:
gt;
gt; I am trying to average a range of cells which sometimes includes blank
gt; cells, which returns: #DIV/0! This happens when the entire range is
gt; blank, but works fine when data is present. I would also like for it
gt; to display quot;NOquot; instead of #DIV/0!
gt;
gt; The formula I used was: =AVERAGE(B4:M4)
gt;
gt; Any help is much appreciated!
gt;
gt; --
gt; Areaka
gt; ------------------------------------------------------------------------
gt; Areaka's Profile: www.excelforum.com/member.php...oamp;userid=33426
gt; View this thread: www.excelforum.com/showthread...hreadid=532426

--

Dave Peterson


Oh, thank you so much, I was working it and reworking it with IF
functions and not getting anywhere. I plugged yours in and
instantaneous!!! Thank you so much!!!!--
Areaka
------------------------------------------------------------------------
Areaka's Profile: www.excelforum.com/member.php...oamp;userid=33426
View this thread: www.excelforum.com/showthread...hreadid=532426