how can i do this?

F

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

Irina

fivermsg said:
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?
Click to expand...

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

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