For right now I am going to stick with the nasty INDIRECTs until I can get a
handle on this headache! I have tried several options with no luck...where
exactly do you add the extra condition that it must be non-blank and non-zero?

=IF(SUMIF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Ty pe_ARRAY,3,FALSE)),$B3,Qualified),AVERAGE(IF(INDIR ECT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,FALS E))=$B3,Qualified)),"-")