According to Excel Help, MEDIAN ignores blank cells (and those
containing text or logical values).

Hope this helps.

Pete

On Nov 24, 8:27 pm, jhicsupt
wrote:
What is the formula to ignore blanks? In other words, there are some 0, so I
want to include the 0. However there are some blanks and I want to exclude
the blanks.

Thanks in advance.