Forum Discussion

Copper Contributor

Mar 08, 2019

SUM QUESTION

I need a formula that is will add five cells, then automatically subtract the lowest single cell, and then provide the sum of the highest four.

Formulas and Functions

Twifoo

Silver Contributor

Mar 08, 2019

Stated succinctly, you only need the sum of the highest 4 numbers. Assuming the numbers are in A1:A5, the formula you need is:
=SUMPRODUCT(LARGE(A1:A5,
ROW(1:4)))