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

[PCat]

sum the lowest 10 cells in a column

 

[Jacob Skaria]

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

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

If this post helps click Yes

 

[Mike H]

Perhaps you mean the last 10 numbers in a column

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

Mike

 

[T. Valko]

Try this:

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