Freeze row when sum for that row reaches 30

Need help with following Employee Leave Accrued Schedule:
Max days allowed is 30 days in a year, so the moment total (cell ref:O12) days taken reaches 30 days, days taken row should get freeze or it should not allow to enter any thing in Days taken row(cell ref- C12:N12)
Thanks!


Employee Name:

Year: 2013

Leave Days:15 Max Days Allowed:30

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Total
Working Days 23 20 21 22 23 20 23 22 21 23 218
Accrued 1.58 1.38 1.44 1.51 1.58 1.38 1.58 1.51 1.44 1.58 15
Days Taken - - - - - - - - - - -
Balance 1.58 2.96 4.40 5.92 7.50 8.88 10.46 11.97 13.42 15 15

Not sure how (or where) you are calculating this, but this formula might help you:

=MIN(30,sum($B$4:B$4))

when copied across would give you a cumulative count of row 4 up to a maximum of 30.

Hope this helps.

Pete

Thank you this would be helpful.

---------- Post added at 01:48 PM ---------- Previous post was at 01:45 PM ----------

Thank you for your help.