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

Yes, if the cells truly are empty.

Looks like an array may be the best solution.

Biff

"Aladin Akyurek" wrote in message
...


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.