+ Reply to Thread
Results 1 to 4 of 4

Freeze row when sum for that row reaches 30

  1. #1
    Registered User
    Join Date
    07-28-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    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

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,177

    Re: Freeze row when sum for that row reaches 30

    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

  3. #3
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Freeze row when sum for that row reaches 30

    I think you mean once the Days Accrued = 30 days, stop accruing

    Your accrued formula for each month would be =if(Accrued_Total+Working_Days_this_month<30,Working_Days_this_month*.069,"")
    Click on star (*) below if this helps

  4. #4
    Registered User
    Join Date
    07-28-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Freeze row when sum for that row reaches 30

    Thank you this would be helpful.

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

    Thank you for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1