Home |
Search |
Today's Posts |
#1
|
|||
|
|||
smallest
how can I summarize the 12 smallest numbers in a column of 20 numbers WITHOUT
the cells that contain a 0. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranking cells largest to smallest | Excel Discussion (Misc queries) | |||
Return the smallest value | Excel Worksheet Functions |