smallest

J

jan jan

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

Bob Phillips

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
 
Top