Stop summing

[BSnyder]

Say I want to sum a range of ten cells, but the total of the ten cells cannot exceed a given value. What formula could I use to add the values in the cells until it hit the max, then stop counting yet keep displaying the max until the sum is once again below the max? Please help!

 

[Juan Pablo González]

=MIN(MyLimit,SUM(A1:A10))

 

[BSnyder]

Thank you so very much, I've been troubling over this for weeks!