Average function with If
 

I'm using Excel 2002 within Office XP for Small Business ver 2002. I want to
calculate the average excluding zero values. I have used the following
formula:

=AVERAGE(IF(Q5:Q35<0,Q5:Q35,""))

This is correct according to the help function and is also correct on a
later version of small business.

Any ideas what I'm doing wrong? thx.

Hi
have you entered this formula as array formula (entered with
CTRL+SHIFT+ENTER)?

--
Regards
Frank Kabel
Frankfurt, Germany

"Danny" schrieb im Newsbeitrag
...
I'm using Excel 2002 within Office XP for Small Business ver 2002. I
want to
calculate the average excluding zero values. I have used the
following
formula:

=AVERAGE(IF(Q5:Q35<0,Q5:Q35,""))

This is correct according to the help function and is also correct on
a
later version of small business.

Any ideas what I'm doing wrong? thx.

Thanks Frank ... that's what I forgot.

"Frank Kabel" wrote:

Hi
have you entered this formula as array formula (entered with
CTRL+SHIFT+ENTER)?

--
Regards
Frank Kabel
Frankfurt, Germany

"Danny" schrieb im Newsbeitrag
...
I'm using Excel 2002 within Office XP for Small Business ver 2002. I
want to
calculate the average excluding zero values. I have used the
following
formula:

=AVERAGE(IF(Q5:Q35<0,Q5:Q35,""))

This is correct according to the help function and is also correct on
a
later version of small business.

Any ideas what I'm doing wrong? thx.