How about
=SUM(SMALL(A:A,ROW(INDIRECT("1:"&B1))))
entered as an array formula with CTRL+SHIFT+ENTER
Worked for me with one small dataset
Oh but you want to skip 1 column (or row?)
If the 'missed cells are blank or have text all is well
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
To add the smallest 50% values in A1, A3, A5, A7:
SUM( SMALL( (A1,A3,A5,A7), {1,2} ) )
How do I do this if the length of my list is not fixed. Say, the
length is stored in B1. Assume the list always starts at A1 and skips
1 column.