Stop summing

BSnyder · Feb 22nd, 2002, 01:37 PM

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 · Feb 22nd, 2002, 01:56 PM

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

BSnyder · Feb 22nd, 2002, 02:00 PM

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

Feb 22nd, 2002, 01:56 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	=MIN(MyLimit,SUM(A1:A10)) __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 01:37 PM	#1
BSnyder New Member Join Date: Feb 2002 Posts: 2	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!

Feb 22nd, 2002, 02:00 PM	#3
BSnyder New Member Join Date: Feb 2002 Posts: 2	Thank you so very much, I've been troubling over this for weeks!