HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL

[FUNACH]

NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6?

 

[HelpExcel.com]

You can use a formulaic array similar to the following:

=AVERAGE(IF(RANK(A1:A10,A1:A10)>4,A1:A10,""))

Make certain you replace A1:A10 with the range of numbers you want to
average and press cntrl-shift-enter

 

[HelpExcel.com]

You can use a formulaic array similar to the following:

=AVERAGE(IF(RANK(A1:A10,A1:A10)>4,A1:A10,""))

Make certain you replace A1:A10 with the range of numbers you want to
average and press cntrl-shift-enter

 

[T. Valko]

Try this:

=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))

 

[T. Valko]

Try this:

=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))

 

[Jacob Skaria]

Refer your other post.. Please dont multi-post . Also avoid using caps in
subject....

 

[Jacob Skaria]

Refer your other post.. Please dont multi-post . Also avoid using caps in
subject....

 

[Paul C]

If you only have 10 items use the Large function to subtract the 4 largest

Exapmle data in cells A3:J3

=(SUM(A3:J3)-LARGE(A3:J3,1)-LARGE(A3:J3,2)-LARGE(A3:J3,3)-LARGE(A3:J3,4))/6

if the number of cells floats use the Small function to get the six smallest

=(SMALL(A3:J3,1)+SMALL(A3:J3,2)+SMALL(A3:J3,3)+SMALL(A3:J3,4)+SMALL(A3:J3,5)+SMALL(A3:J3,6))/6

 

[Paul C]

If you only have 10 items use the Large function to subtract the 4 largest

Exapmle data in cells A3:J3

=(SUM(A3:J3)-LARGE(A3:J3,1)-LARGE(A3:J3,2)-LARGE(A3:J3,3)-LARGE(A3:J3,4))/6

if the number of cells floats use the Small function to get the six smallest

=(SMALL(A3:J3,1)+SMALL(A3:J3,2)+SMALL(A3:J3,3)+SMALL(A3:J3,4)+SMALL(A3:J3,5)+SMALL(A3:J3,6))/6

 

[Robert McCurdy]

Array entered: ctrl + shift + enter

=AVERAGE(SMALL(A2:A11,ROW($1:$6)))


Regards
Robert McCurdy

 

[Robert McCurdy]

Array entered: ctrl + shift + enter

=AVERAGE(SMALL(A2:A11,ROW($1:$6)))


Regards
Robert McCurdy