how can i do this?

[fivermsg]

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?

[SteveG]

Try this.

=IF(ISERROR(M20),G20,AVERAGE(G20,M20))


Does that help?

Steve

[Irina]

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?

May be you should check is it number or not. Something like this:
=IF(AND(ISNUMBER(A13),ISNUMBER(B13)),AVERAGE(A13:B13),"")

[Dave O]

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