SUMIF & MEDIAN with blanks & text
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?
|