Thread: smallest
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.