# Solved Calculate the Average of row of 18 numbers

November 10, 2015 at 01:06:50
Specs: Windows 7
 I have multiple rows, of 18 columns, containing individual player game scores. Blank cells represent missed games. End of season ranking are determined by those players with the highest average game scores over 18 rounds dropping the three lowest scores including missed games. I am currently using a table with a column of end of season game scores then manually subtracting the three lowest scores (blanks count as zero) from the total and dividing by 15. Having a fx or combination of to auto calculate this final step would be much appreciated.

See More: Calculate the Average of row of 18 numbers

#1
November 10, 2015 at 08:19:19
 Blank cells represent missed games. End of season ranking are determined by those players with the highest average game scores over 18 rounds dropping the three lowest scores including missed games.The simplest solution is to change your Blank Cells to Zero and the first formula will work.=(SUM(A1:A18)-SMALL(A1:A18,1)-SMALL(A1:A18,2)-SMALL(A1:A18,3))/(COUNT(A1:A18)-3)The SMALL() function and the COUNT() function both ignore Blanks, but Excel recognizes Zero as a valid number. MIKEhttp://www.skeptic.com/

Report •

#2
November 10, 2015 at 11:00:29