Thread: How do I sum the lowest n numbers in an array with n variable?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tushar Mehta Tushar Mehta is offline
external usenet poster
  
Posts: 1,071
Default How do I sum the lowest n numbers in an array with n variable?
In article ,
says...


Suppose your data are in A1:A3 and 'n' is in D1. Then use the array formula
=SUM(SMALL(A1:A3,ROW(INDIRECT("1:"&D1))))

If you have a follow up question please use the body of the post for it and
not just the subject line.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Reply With QuoteReply With Quote