I was able to fix everything else except the Averages & Medians along with
the incorrect best finish of 0.00 for FSB Pro Cup Season 13 (Stats Sheet -
selecting by Season). The Stats sheet is protected but can be unprotected by
leaving the password blank. I uploaded the latest version to the same place:

http://www.oatas.net/personal/Online...Statistics.xls


The Averages & Medians are reporting the wrong values in some case - FSB Pro
Cup Season 13 is a good example.....

Avg Qual it's reporting: 2.90 Avg Qual (what it should be): 7.25
Median Qual it's reporting: 0.00 Median Qual (what it should be): 2.50

Avg Fin it's reporting: 3.45 Avg Fin (what it should be): 8.63
Median Fin it's reporting: 0.00 Median Fin (what it should be): 4.50

I imagine virtually every other Med & Avg are not working correctly where
blanks exist?

"T. Valko" wrote:

Did you see my last reply to your other post? I couldn't open the link.

Anyhow...

MEDIAN shouldn't have an issue delaing with blanks/deleted
cells and the formula above works fine in other cases where
there are blanks.

If:

IF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRA Y,3,FALSE))=$C3

=TRUE and the corresponding cell in Qualified is empty that corresponding
cell will be included in the calculation as a 0.

Like this:

x...1
x....
x...5

MEDIAN(IF(rng1="x",rng2))

The result is 1.. The empty cell is being evaluated as 0:

MEDIAN({1;0;5})

To account for that:

MEDIAN(IF((rng1="x")*(rng2<""),rng2))

--
Biff
Microsoft Excel MVP


"Brian" wrote in message
...
I had some help putting together this formula, but it has been giving me
some
grief for some reason after it seemed to work ok to start with.....

=IF(SUMIF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Ty pe_ARRAY,3,FALSE)),$C3,Qualified),MEDIAN(IF(INDIRE CT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,FALSE ))=$C3,Qualified)),"-")

The data it is evaluating can have text, blanks, or numbers in the range,
"Qualified." In this case, it only has numbers and blanks. MEDIAN
shouldn't
have an issue delaing with blanks/deleted cells and the formula above
works
fine in other cases where there are blanks. Any suggestions?