Help with Data Validation

[neverT00late]

Hi I'm trying to see if this is doable. Here is my query

Column A , B , C
Column A & B take user input
Column C is constant with a numeric value
I'd like to perform a data validation so that the column A & B won't take a numeric value greater than the value in column C and if the values from both A & B put together must not be greater than column C

A = 0
B = 3
C = 4
The above scenario is valid

A=2
B=3
C=4
This scenario is invalid because the sum is greater than C.


Any thoughts would be helpful.

Thanks

[XLent]

Perhaps, a custom validation rule, applied to A:B, of:

=COUNT(A1)/(SUM($A1:$B1)<=$C1)

to test, highlight both A1:B1 (selecting from A1 to B1) then insert the above rule.

[neverT00late]

thank you so much, this works like a charm.