Try the data validation formula

=a1SUM(a2:a14)

Mike

"ollie" wrote:

I want to create a data validation formula that will allow me to input an
amount into a1 cell only if it is greater than the values in cells a2 to a14
. If there are no values in a2 to a14 I also wish to allow the value in a1 to
be input