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?
Philip West
Sep 21, 2018Iron Contributor
something like this might work:
=SUMIF(A1:A10,">=" & LARGE(A1:A10,4))+B1
Adjust the ranges to match your data.