data validation issue

[iwtci]

Hi everyone,

Could some one help me out with this problem

say i have a total quantity in b5, and partial quantities in c5:c10.
i want to have some type of data validation for cells c5:c10 to preven
the total sum of these cells from exceeding the amount in b5.

i tried a the follwoing function in data validation
=sum(c5:c10)<=b5

however, it is not working properly.

sure it is easy, but i can not see what i am missing

tia

khaldou

 

[Domenic]

Hi,

Try,

=SUM($C$5:$C$10)<=$B$5

Hope this helps

 

[Frank Kabel]

Hi
try
=SUM($C$5:$C$10)<=$B$5

 

[iwtci]

Thanks frank,

it works like magic

all the bes