Microsoft KB Archive/60727: Difference between revisions
From BetaArchive Wiki
m (Text replacement - ">" to ">") |
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/") |
(No difference)
|
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.