Forum Discussion
David O'NEILL
Sep 21, 2018Copper Contributor
Need help with SUM formula
I want to sum the 4 highest values in a range and then add a value from another column, but can't find the right formula. Can anyone help?
1 Reply
- Philip WestIron Contributor
something like this might work:
=SUMIF(A1:A10,">=" & LARGE(A1:A10,4))+B1
Adjust the ranges to match your data.