The formula you provided does have an error in it somewhere

Yeah, my fault. I used the wrong range!

Try this one (array entered):

=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 )*(Qualified<""),Qualified)),"-")


--
Biff
Microsoft Excel MVP


"Brian" wrote in message
...
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