any suggestions?
 

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

any suggestions?
 

The way you have this set up, your AVERAGE function is only averaging one
number, the result of G20+M20. Try this:

=AVERAGE(IF(ISNUMBER(G20),G20),IF(ISNUMBER(M20),M2 0))

HTH,
Elkar


"fivermsg" wrote:


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

any suggestions?
 

=AVERAGE(IF(ISNUMBER(G20),G20),IF(ISNUMBER(M20),M2 0))

Since you are summing the two arguments, you are asking AVERAGE to
compute the average of a single number.By supplying the two arguments
you are now not interfering with the calculations of AVERAGE.

HTH
Kostis Vezerides

any suggestions?
 

The problem is the plus sign- AVERAGE requires that the arguments are
separated by a comma. Try this:
=(AVERAGE(IF(ISNUMBER(G20),G20),(IF(ISNUMBER(M20), M20))))
....and you'll get the desired results.