Microsoft KB Archive/60727: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q60727 to Microsoft KB Archive/60727 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
||
(2 intermediate revisions by the same user not shown) | |||
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. |
Latest revision as of 19:26, 12 August 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.