using this formula
=(AVERAGE(IF(ISNUMBER(G20),G20)+(IF(ISNUMBER(M20), M20))))

My G20=62.5 and my M20=30...... My formula gives me 92.5, but i want
the average not the total.. why won't average work here?

Keep in my sometimes when G20=NUMBER, M20=#DIV/0!, so that is why i
have "isnumber" in there..

Help..


--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521141