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.