S
shaggy56
how do i take a column of 4 digits and get the sum of the 2 smallest i
the colum
the colum
V
Vasant Nanavati
=SUM(SMALL(D2
10,{1;2}))
entered as an array formula with <Ctrl> <Shift> <Enter>. This should work
whether or not the 4 digits are in consecutive rows.
10,{1;2}))entered as an array formula with <Ctrl> <Shift> <Enter>. This should work
whether or not the 4 digits are in consecutive rows.
D
duane
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
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