According to the help files for the MEDIAN function, it already does this.

"If an array or reference argument contains text, logical values,
or empty cells, those values are ignored; however, cells with
the value zero are included"

Rick


"jhicsupt" wrote in message
...
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.