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..

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),M20))

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

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

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

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.