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

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




jhicsupt wrote:

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))

"Rick Rothstein (MVP - VB)" wrote:

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.



--

Dave Peterson