Results 1 to 5 of 5

Formula to allocate sales orders based on working days

Threaded View

  1. #1
    Registered User
    Join Date
    11-05-2020
    Location
    Manchester, England
    MS-Off Ver
    Office 365
    Posts
    10

    Formula to allocate sales orders based on working days

    I have 6 team members. Every Monday I run a report which shows how many sales orders were processed for the previous week. The report can't tell me who on my team processed the order so I want to proportion out total orders based on who was working each day of the week.

    Attached is a sample file. Data in the yellow cells shows the report data I can pull showing orders processed by day.
    I would like a formula in the orange calls (showing fabricated numbers) which takes the orders and proportions them to each member of the team based on if they were working that day, rather than having to figure it out manually, using a link to the holiday tracker shown on the other tab.

    eg: On 8/11/20, Nick was on holiday, so orders need to be split across the remaining 5 team members. On 9/11/20, all team members working, so can be split across all 6. On 10/11/20, Kim and Gavin were off, so split that days orders across the remaining 4 team members etc. So I get a total per person for the week which comes back to total orders processed.

    TIA!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for # of sales orders per month
    By bmiller603 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2019, 04:17 PM
  2. Allocate orders into production batches (max. weight in each)
    By Wardinho in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2018, 06:38 PM
  3. formula to get number of working days in a month based on criteria
    By aravindhan_31 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 08-15-2016, 06:22 AM
  4. [SOLVED] Distribute/Allocate working days of the month accross multiple projects.
    By MuchieMac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-27-2016, 04:50 AM
  5. Find Each Days Orders by Associate ID, input into Master Orders COmpleteWorksheet
    By bbell2219 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2016, 02:14 AM
  6. Formula to Average Days of Distinct Orders
    By tjfulmer1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-12-2013, 02:36 PM
  7. Formula that shows commonly sold trends across multiple sales orders
    By papajpp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-05-2013, 11:05 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