Thread
:
Create formula to; sum the lowest 10 cells in a column
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
Posts: 8,520
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
Reply With Quote
Jacob Skaria
View Public Profile
Find all posts by Jacob Skaria