I want to auto-sum and not exceed a certain number

jt4lsu · Jan 12, 2009

I have a column that I am using auto-sum. The total of that column cannot
exceed a certain number. What is the formula?

Mike H · Jan 12, 2009

Hi,

Change 1000 to whatever your maximum value

=MIN(1000,SUM(A:A))

Mike

Gord Dibben · Jan 12, 2009

=MIN(100,SUM(A1:A10)) will return 100 if the SUM is more than 100

Gord Dibben MS Excel MVP