Biff wrote:
Hi!

Median ignores empty cells so I'm assuming your values are the result of
other formulas and you have the display of zeros suppressed.


The INDEX expression you invoked will evaluate empty cells to 0's.