Data validation don’t exceed total in Excel

Data validation don’t exceed total in Excel

Refer the formula for the data validation don’t exceed total in Excel.

If you are in a rush and want your problem answered, email to exploresarcs@gmail.com or live chat with us.

Choose custom option in data validation and enter the corresponding range. Refer to the sample formula given below.

=sum($A$1:$A$10)<=100


Also, add error message alert, if required.

https://exceljet.net/formula/data-validation-dont-exceed-total

About the author: admin

You must be logged in to post a comment.