Average function with If

[Danny]

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.

 

[Frank Kabel]

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

 

[Danny]

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

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