Sum of a range of cells, dropping the highest number in the range.

Hello dlkosko1958,

Just another for fun:

=SUMPRODUCT(SMALL(array,{1,2,N}))

where N is the Nth largest value in the array.

For example, with N+1=5 numbers that would be:

 =SUMPRODUCT(SMALL(array,{1,2,3,4}))

 If N+1=13 numbers that would be:

 =SUMPRODUCT(SMALL(array,{1,2,3,4,5,6,7,8,9,10,11,12}))

This is an array formula so press Ctrl+Shift+Enter to execute. 

dlkosko1958 

For the collection

dlkosko1958 

Another option:

Hi dlkosko1958 

Assuming your data range is column A, you may try below formula

=SUM(A:A)-MAX(A:A)

Thanks

Tauqeer