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.