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

  • Thread starter Thread starter jt4lsu
  • Start date Start date
J

jt4lsu

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

Change 1000 to whatever your maximum value

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

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


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF and MOD functions 2
setting row height not to exceed... 1
SUMPRODUCT with criteria including OR function 4
Numbers showing Up Centered in Cell ? 1
Summing 2 columns cells into a 3rd colums cells 1
Formual to have Max $ amount 12
Error when using Sum command 3
Sum Product not good enough 1

Back
Top