Microsoft KB Archive/60727

Excel: Ignoring Zeros Using the AVERAGE Function PSS ID Number: Q60727 Article last modified on 05-22-1991 PSS database name: M_eXceL

1.00 1.03 1.04 1.06 1.50 2.20 3.00

MACINTOSH

Summary:

The following formula calculates the average of a range of numbers, while ignoring any zero values that are present in the range:

=AVERAGE(IF(range<>0,range,&quot;&quot;))

This formula is an array formula and must be entered by pressing COMMAND+ENTER on the keyboard.

Note: The AVERAGE function in Excel automatically ignores blank cells, while zero values are calculated.

Copyright Microsoft Corporation 1991.