Sum of a range dont have to be over 8

  • Thread starter Thread starter Jack Daniels
  • Start date Start date
J

Jack Daniels

Hi!

I have a workshhet where people are booking themselves for different
programs. But there is a limit, for example the SUM of D2:D10 don´t
have to be more than 8. How do I stop a user to put in any number when
th SUM has reached 8?

Jack
 
Try this:

Select D2:D10, then go to Data/Validation, next select "custom" from the
"Allow" menu and in the formula box type:

=SUM($D$2:$D$10)<=8

next click on the "Error Alert" tab and leave a message for the user.

HTH
JG
 
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

Conditional sum in a named range 8
How to find SUM when you already have the range? 4
Sum number range ignoring numbers formatted as text 0
sum a specific range 7
SUM OF A RANGE 8
Summing based on a range of dates 3
Adding 8 columns by formula 1
Summing between Range 2

Back
Top