Median - Ignore blanks

  • Thread starter Thread starter jhicsupt
  • Start date Start date
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.
 
According to Excel Help, MEDIAN ignores blank cells (and those
containing text or logical values).

Hope this helps.

Pete
 
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
 
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))
 
How about instead of this portion:
*(Oct2!$AU$2:$AU$1763>=1)

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