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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies