Median - Ignore blanks

J

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.
 
P

Pete_UK

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

Hope this helps.

Pete
 
R

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
 
J

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:
Click to expand...
=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))
 
D

Dave Peterson

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

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