Median - Ignore blanks

[jhicsupt]

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.

 

[Pete_UK]

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

Hope this helps.

Pete

 

[Rick Rothstein \(MVP - VB\)]

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]

I am using an IF statement and it is not ignoring the 0. I had to put in the

=1. However I want to include 0. Here's my statement:

=MEDIAN(IF((Oct2!$G$2:$G$1763=$C$2)*(Oct2!$T$2:$T$1763=Z59)*(Oct2!$V$2:$V$1763=Z60)*(Oct2!$AU$2:$AU$1763>=1),Oct2!$AU$2:$AU$1763))

 

[Dave Peterson]

How about instead of this portion:
*(Oct2!$AU$2:$AU$1763>=1)

you try:
*(Oct2!$AU$2:$AU$1763<>"")