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