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,""))
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.