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.