Microsoft KB Archive/24292

{| = Excel: Functions Ignore Blank Cells to Calculate Result =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q24292

SUMMARY
Microsoft Excel functions that return a numeric value ignore blank cells.

For example, if a range of cells is to be averaged, blank cells in this range will not be considered in the calculation of the average value for these cells.
 * }