+ Reply to Thread
Results 1 to 3 of 3

Formula to calculate number of employees per new location added

  1. #1
    Registered User
    Join Date
    12-02-2022
    Location
    Karachi, Pakistan
    MS-Off Ver
    Office 365
    Posts
    4

    Formula to calculate number of employees per new location added

    Hello, I need help with a formula.

    Year Locations Added

    2023 1
    2024 1
    2025 2
    2026 2
    2027 3
    2028 6
    2029 7

    I want to add 1 new employee every 3 new locations added.
    For Example: In 2023, 1 new location is added therefore no new employee in 2023. In 2024, 1 new location is added therefore the sum is now 2 hence again no new employee should be added in 2024. But in 2025, 2 new locations are added. If you take the cumulative sum of new locations, it is now 4. So one new employee should be added. (Sum = 4 : 1 New employee per 3 locations) and the remaining 1 location from 4 should be carried forward to the next year and sum should start again until it reaches 3.

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,009

    Re: Formula to calculate number of employees per new location added

    Try this in C2 and copied down.

    =INT((SUM($B$2:B2)-3*SUM($C$1:C1))/3)

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,069

    Re: Formula to calculate number of employees per new location added

    Try, C2=QUOTIENT(SUM(B$2:B2),3), copy down.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with a formula to calculate employees productivity bonus
    By Longbow 44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2023, 09:28 AM
  2. Calculate number of employees working each hour.
    By vdillon in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-21-2021, 08:47 PM
  3. Replies: 2
    Last Post: 08-03-2020, 10:10 AM
  4. Calculate Number of Employees Who Were At Work Each Hour?
    By cr2crf in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-13-2017, 10:42 AM
  5. Time formula to calculate employees working
    By shockwaveaz in forum Excel General
    Replies: 7
    Last Post: 11-29-2016, 06:29 AM
  6. [SOLVED] How to calculate number of employees per department position
    By ancherilvm in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-28-2014, 12:26 AM
  7. [SOLVED] Need formula to calculate commissions for employees based on the month earned on 2 sheets
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-02-2013, 12:09 AM

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