LOL - this sheet is pretty ugly but it does do as intended for better or
worse. The formula you provided does have an error in it somewhere - I'll
take a look and see if it's a missing paratheses, but I don't think is the
issue.

=IF(SUMIF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Ty pe_ARRAY,3,0)),$B3,Qualified),AVERAGE(IF(INDIRECT( VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,0))=$B3) *(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY ,3,0))<""),Qualified)),"-")

"T. Valko" wrote:

This is going to be really ugly!

=IF(SUMIF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Ty pe_ARRAY,3,0)),$B3,Qualified),AVERAGE(IF(INDIRECT( VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,0))=$B3) *(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY ,3,0))<""),Qualified)),"-")--BiffMicrosoft Excel MVP