Forum Discussion

David O'NEILL's avatar
David O'NEILL
Copper Contributor
Sep 21, 2018

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 West's avatar
    Philip West
    Iron Contributor

    something like this might work:

     

    =SUMIF(A1:A10,">=" & LARGE(A1:A10,4))+B1

     

    Adjust the ranges to match your data.

Resources