Data Validation. Enter any value in a range of Cells as long as total doesnt exceeds 100%

[excobra]

I have 15 rows with different headings like

A1
A2
A3
A4
A5

A6 Total 100%

I want to add any percentage from zero to 100 as long as total in A6 doesn't exceeds 100%.

[ragulduy]

=IF(A6<=100,sum(A1:A5),"")
or
=IF(A6<=1,sum(A1:A5),"")
dependant on how your percentages are stored.

[shcon]

Select all cells under head of A1 to A5 => go to validation and then choose custom => key in below formula:
=SUM($B$3:$F$3)<=1

Then you will able to input every thing untill A6 is more than 100%
Check my attached file for example.
Book1.xlsx

Please consider to give me some like on star near "Add reputation".

[excobra]

Thanks Guys. I will try it now and come back with feedback.