Data Validation

[Fred L]

I need some help with something simple, or so I thought.
I need a validation rule that when the sum of a range
exceeds 3, I get a validation error. The Maximum value for
sum of D38 can be 3. Example: If I type anything larger
than 1 in D5,I need a validation error.
I tried several formulas i.e =if(sum(d3:d8>3) but to no
avail.

Column D
3 1
4 1
5
6
7
8

Thanks for the help !

 

[Peo Sjoblom]

Select D38, do data>validation, allow custom and use this formula

=SUM($D$3:$D$8)<=3

 

[C]

I know you said you tried it, but try typing this formula:
"=if(sum(d3:d8)<=3,"","Error!")