How do I sum the lowest n numbers in an array with n variable?

T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

union array 14
how do i create a pie chart in excel with non-numerical values? 1
Reference to the N-largest value in an array 4
Can you combine an Excel Cluster Bar Graph with a Stacked Bar Grap 1
how do I set up a outlier in excel graph? 2
is there any sample of an excel dashboard ? 2
How to supress #N/A in an array formula. 5
How do I get XL2003 to default save overwriting the original? 3

Top