Can a validation be carried out on a dependent i.e on a function in a cell
e.g =sum(A1..A2), so that it cannot exceed say 100.

Thanks.