smallest
 

how can I summarize the 12 smallest numbers in a column of 20 numbers WITHOUT
the cells that contain a 0.

Jan,

Try this

=SUM(SMALL(IF(A1:A20<0,A1:A20),ROW(1:12)))

It is an array formula, so commit with Ctrl-Shift-Enter

--
HTH

-------

Bob Phillips
"jan jan" <jan wrote in message
...
how can I summarize the 12 smallest numbers in a column of 20 numbers
WITHOUT
the cells that contain a 0.