A complicated Data Validation question

[Wunderbarre]

Hi gurus,

I am trying to come up with the data validation as shown in the file attached.

the rules are as follows.

[TABLE="width: 1296"]
<colgroup><col span="12"><col></colgroup><tbody>[TR]
[TD]http://tinypic.com/r/312xn2a/9

I am new to this forum so pardon me if there are any violations of the forum rules.[/TD]
[TD="colspan: 6"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Rijnsent]

Hi Wunderbarre,
a picture helps a lot, but if you describe your problem here it might be of more use to other people, as the picture might be removed at some point.
For row 6 this is your validation formula (for all cells including the total):
=SUM($B6:$G6)<=$H6
If you either lower the total or insert a value which causes the sum to be higher than the total it will show the validation error.
Cheers,
Koen

 

[kvsrinivasamurthy]

Formula is

=SUM($A13:$F13)<=$G13

Select A13:F16.
Data --> Data Valdation
Allow--> custom, Formula-->Enter formula
For input message
Sum of the range form A:F should not exceed Column G value.