Monday, July 22, 2013

yogi_Compute In Range C7:M7 Sum OF Specified Number Of Smallest Numbers Meeting Given Conditions

                                          Google Spreadsheet   Post  #1301
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul 22, 2013
user AndyKH (!category-topic/docs/spreadsheets/how-do-i/desktop/mF3bOtOcZDc)
=sum(small(C7:M7,{1,2,3,4,5,6})) but ignore zeros ?
I would like to sum the six smallest numbers in a range C7 to M7 but the range has zeros which I need to ignore.

It is part of a larger formula
=if(P4>=6,sum(small(C4:M4,{1,2,3,4,5,6}))," ")

P4 is the total number of rounds completed in a sports group league table.

Hope thats enough info, many thanks for any help,