I missed it Biff.........but I have fixed those areas - or at least thought I
did. I will host the file at this site:

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

and delete it when we are finished (5 MB). It's almost completed except
instructions.....

Shane, I thought that was a possibility as well and so I copied other blank
cells which were being calculated correctly (ie not calc'd at all) to the
offending league entries. Specifically, FSB Pro Cup Season 13 in the Stats
Sheet in cell Y11. (auto calc is turned off - just click the button I made
that is on the sheet to re-calc it.

BTW, thanks to all of you who have helped - this thing is a beast that I
couldn't have done without the helpful information on these forums.

For some reason the 'by Season' selection dropdown is giving funky
statistics for totals across row A as compared to all of the other
selections. I don't quite understand that one :(

"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?