• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum cells in a column until value reached

K

kmac

New Member
Hi,

I'd like to sum up cells C5:I5 until a min value of £50k (shown in row 3) is reached. If the value in cells C5:I5 is already >£50k then the cell returned as is, if not, add up until £50k reached.

See test file and hopefully this question makes sense!

Thanks
 

Attachments

  • test file.xlsx
    9.2 KB · Views: 14
You must log in or register to reply here.
Back
Top