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

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

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

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
--
Regards,
Eddie
http://www.HelpExcel.com


"FUNACH" wrote:

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

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

Try this:

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

--
Biff
Microsoft Excel MVP


"FUNACH" wrote in message
...
NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6?

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

Refer your other post.. Please dont multi-post . Also avoid using caps in
subject....
--
If this post helps click Yes
---------------
Jacob Skaria


"FUNACH" wrote:

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

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

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)+SMA LL(A3:J3,4)+SMALL(A3:J3,5)+SMALL(A3:J3,6))/6

--
If this helps, please remember to click yes.


"FUNACH" wrote:

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

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

Array entered: ctrl + shift + enter

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


Regards
Robert McCurdy
"FUNACH" wrote in message
...
NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6?