Create formula to; sum the lowest 10 cells in a column
 

sum the lowest 10 cells in a column

Create formula to; sum the lowest 10 cells in a column
 

You mean lowest 10 values in a column...Try

=SUMPRODUCT(SMALL(A:A,ROW(1:10)))

If this post helps click Yes
---------------
Jacob Skaria


"PCat" wrote:

sum the lowest 10 cells in a column

Create formula to; sum the lowest 10 cells in a column
 

Perhaps you mean the last 10 numbers in a column

=SUM(OFFSET(A1,COUNTA(A:A)-10,):OFFSET(A1,COUNTA(A:A),))

Mike

"PCat" wrote:

sum the lowest 10 cells in a column

Create formula to; sum the lowest 10 cells in a column
 

Try this:

=SUM(SMALL(A:A,{1,2,3,4,5,6,7,8,9,10}))

--
Biff
Microsoft Excel MVP


"PCat" wrote in message
...
sum the lowest 10 cells in a column