Validating Cell Calculations

  • Thread starter Thread starter TMS
  • Start date Start date
T

TMS

I have a column of cells that sum at the bottom. I want to set up a
validation that will generate an error message if any entry into the
column of cells causes the sum to go over a certain, set amount.

Anybody have any ideas?
 
If the formula were something like: =SUM(B2:B50), you could say:

=SUM(B2:B50) & IF(SUM(B2:B50)>1000, " - Sum too high","")

Note that you could not use the error value in a further calculation as it
would not be a numeric entry. A better way might be to use Conditional
Formatting to highlight the cell contents if it exceeds the value. I would
suggest you put the limiting value in another cell on the sheet to make it
easier to adjust.

Regards

Trevor
 
Back
Top