Microsoft KB Archive/60727: Difference between revisions
From BetaArchive Wiki
m (Text replacement - "<" to "<") |
m (Text replacement - ">" to ">") |
||
| Line 9: | Line 9: | ||
The following formula calculates the average of a range of numbers, while ignoring any zero values that are present in the range: | 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< | =AVERAGE(IF(range<>0,range,"")) | ||
This formula is an array formula and must be entered by pressing COMMAND+ENTER on the keyboard. | This formula is an array formula and must be entered by pressing COMMAND+ENTER on the keyboard. | ||
Revision as of 10:50, 21 July 2020
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.
