how do i take a column of 4 digits and get the sum of the 2 smallest i
the colum

--
Message posted from http://www.ExcelForum.com

=SUM(SMALL(D2:D10,{1;2}))

entered as an array formula with <Ctrl <Shift <Enter. This should work
whether or not the 4 digits are in consecutive rows.

--

Vasant

"shaggy56 " wrote in message
...
how do i take a column of 4 digits and get the sum of the 2 smallest in
the column


---
Message posted from http://www.ExcelForum.com/

not sure if this wil help, but if you can, sort (ascending) and add to
two rows. if you can't sort, build separate database referrenced t
the original like =$a$1 for cell a1, and =$a$2 for cell a2, etc an
then do the sort on this list - this could be place on a separate shee
if need be. the idea is to creat e the list sorted low to high (in
known position) so you can just add two cells

--
Message posted from http://www.ExcelForum.com