software

here we go,

what i would like to do is take the value in g20 and m20 add them
together and take the average..BUT... if m20 equals #DIV/0! i still
want g20 to calculate..

ie- g20= 30 and M20= 30 then C20=30, this is good
ie- g20= 30 and M20= #DIV/0! then C20=30, this is good

But what i am getting is,

G20= 30 and M20= #DIV/0! then C20=15, this is not
good

any suggestions?--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=521216
Try this.

=IF(ISERROR(M20),G20,AVERAGE(G20,M20))Does that help?

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=521216
fivermsg Wrote:
gt; here we go,
gt;
gt; what i would like to do is take the value in g20 and m20 add them
gt; together and take the average..BUT... if m20 equals #DIV/0! i still
gt; want g20 to calculate..
gt;
gt; ie- g20= 30 and M20= 30 then C20=30, this is good
gt; ie- g20= 30 and M20= #DIV/0! then C20=30, this is good
gt;
gt; But what i am getting is,
gt;
gt; G20= 30 and M20= #DIV/0! then C20=15, this is not
gt; good
gt;
gt; any suggestions?

May be you should check is it number or not. Something like this:
=IF(AND(ISNUMBER(A13),ISNUMBER(B13)),AVERAGE(A13:B 13),quot;quot;)--
Irina
------------------------------------------------------------------------
Irina's Profile: www.excelforum.com/member.php...foamp;userid=8685
View this thread: www.excelforum.com/showthread...hreadid=521216Use the start of the formula from the previous post, and divide by the
count of numeric cells to get the simple average, comme ca:
=(IF(ISNUMBER(G20),G20) IF(ISNUMBER(M20),M20))/COUNT(G20,M20)