any suggestions?

[fivermsg]

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

 

[Guest]

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

 

[vezerid]

=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

 

[Dave O]

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.