Excel 2000
Posted by R. F. Clear on August 09, 2001 11:47 AM
I have a string of numbers in various cells and I want to know what formula I can use to have Excel look at the string, pick out the two or three smallest numbers, add together those smallest numbers and place that total in a cell.
Posted by Mark W. on August 09, 2001 11:53 AM
Describe your "string of numbers" or give example
Posted by Mark W. on August 09, 2001 12:41 PM
Let me presume...
That by "string of numbers" you mean a set of
numbers entered into a cell range. If that cell
range was A1:A10, then =SUM(SMALL(A1:A10,{1,2}))
would sum the 2 smallest numbers, and the formula,
=SUM(SMALL(A1:A10,{1,2,3})) would sum the 3
smallest. Please understand that if there
are duplicate values among the 2 or 3 smallest
then those duplicates are used. For example,
if your values are {2;3;3;4;5;6;7;8;8;9} the
the 2 smallest would sum to 5 while the 3 smallest
would sum to 8.
