Top Ten average (conditional)

  • Thread starter Thread starter GerryK
  • Start date Start date
G

GerryK

I would like to get a top ten entry average from another
sheet (column K) in my workbook when a condition is met in
another column (B).

This works fine...
=AVERAGE(LARGE('Export'!$K$3:$K$9999,ROW(INDIRECT
("1:10")))) .array entered

But I am having trouble when adding to the formula for
when a condition in column B in the Export sheet is met,
*('Export'!$B$3:$B$9999=39)

I only want the top ten average from K when 39 is in B.
K has blanks but no 0's

I tried starting with =AVERAGE(IF((LARGE. etc. but I must
be missing something.

Any help would be appreciated!

Gerry
 
=AVERAGE(LARGE(IF(Export!B3:B9999=39,Export!K3:K9999),ROW
(INDIRECT("1:10"))))

Array-entered.

HTH
Jason
Atlanta, GA
 
Back
Top