Array enter (enter using Ctrl-Shift-Enter)

=SUMPRODUCT((MOD(ROW(A1:A20),2)=1)*(A1:A20<=(SMALL (IF(MOD(ROW(A1:A20),2)=1,A1:A20),COUNT(A:A)/4)))*A1:A20)

Change all instances of "A20" to be your last filled cell in column A.

Note that for this to be accurate, you would need the count of your filled in cells to be a multiple
of 4....

HTH,
Bernie
MS Excel MVP


wrote in message ups.com...
I do have real data in each row. How can I make every other row to not
be counted when calculating the smallest?


Bernie Deitrick wrote:
Bernard,

My bad - should be COUNT if there's any possibility of text values....but since the list always
starts in A1, sounds like the OP doesn't have headers....

Bernie
MS Excel MVP


"Bernard Liengme" wrote in message
...
COUNTA or COUNT?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
How about:

=SUMIF(A:A,"<="& SMALL(A:A,COUNTA(A:A)/2))

That will work as long as there are an even number of items in column A.

HTH,
Bernie
MS Excel MVP


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.