smallest

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SMALL function to find X smallest number greater than Y 6
finding 10 smallest numbers from last 20 input 8
Find Smallest and Largest. 5
Automatic Sorting? 6
Finding next number in a series 2
Find X number of smallest values in a range 1
Average question 1
Eliminating 0 values when using the Small formula 1

Top