Thread: Create formula to; sum the lowest 10 cells in a column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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
Reply With QuoteReply With Quote