Formula for average of a top 12 numbers in a column of 24 total nu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of 2 games played per month. I'd like to take the average of
the top 12 games of the 24 listed with out having to resort them (I want to
keep them in the order of the months). Is there a way to do this?

It's giving me a lot of stress digging around and trying to find an answer.
This has had to come up before. Thanks in advance.
 
This will average the top 12 largest numbers


=AVERAGE(LARGE(A1:A24,{1;2;3;4;5;6;7;8;9;10;11;12}))


=AVERAGE(LARGE(A1:A24,ROW(INDIRECT("1:12"))))


this formula is volatile


or if you never insert rows above the data


=AVERAGE(LARGE(A1:A24,ROW(1:12)))


the 2 latter formulas need to be entered with ctrl + shift & enter
 
Awesome! The second works perfectly, thanks!

Peo Sjoblom said:
This will average the top 12 largest numbers


=AVERAGE(LARGE(A1:A24,{1;2;3;4;5;6;7;8;9;10;11;12}))


=AVERAGE(LARGE(A1:A24,ROW(INDIRECT("1:12"))))


this formula is volatile


or if you never insert rows above the data


=AVERAGE(LARGE(A1:A24,ROW(1:12)))


the 2 latter formulas need to be entered with ctrl + shift & enter





--

Regards,

Peo Sjoblom
Click to expand...
 
Back
Top