Home

SUM QUESTION

Frank705
Occasional Visitor

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.

1 Reply
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)))
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies