I don't think I'd use data|validation.

I'd use a cell in a prominent spot.

=if(sum(d:d)100,"Error in Column D--cannot exceed 100","")

format it in nice big bold red letters.

shlomo wrote:

I know it's doable with the validation function.

I wont that the total of column D should not be able to be more then
100.
what do I have to enter in the validation function?

--
shlomo
------------------------------------------------------------------------
shlomo's Profile: http://www.excelforum.com/member.php...o&userid=15304
View this thread: http://www.excelforum.com/showthread...hreadid=345568

--

Dave Peterson