+ Reply to Thread
Results 1 to 4 of 4

Help with formula to give me a total by month and year end for each driver.

  1. #1
    Registered User
    Join Date
    07-28-2014
    Location
    United States
    MS-Off Ver
    XP and Windows 7, 8, 8.1
    Posts
    16

    Help with formula to give me a total by month and year end for each driver.

    Hello,
    I have a fleet of trucks and we book loads throughout the month. I have a load sheet that I currently use and I'd like to be able to track the driver/truck number's pay from each month onto another worksheet.

    For example January I have 6 drivers that I choose from on the "Driver/Truck" column drop down and then enter the Load Pay amount for that load.
    I'd like for that to populate from each month by driver onto the last worksheet tab "Monthly Year End Totals"

    Here are some examples of the spreadsheet as well as the actual spreadsheet to work with. I hope someone can help me.

    Load Sheet Example.jpg

    Load Sheet Monthly Tabs.jpg

    Monthly Year End Total Sheet.jpg

    2015 Test Load Sheet.xlsx

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Help with formula to give me a total by month and year end for each driver.

    See attachment
    Attached Files Attached Files
    Quang PT

  3. #3
    Registered User
    Join Date
    07-28-2014
    Location
    United States
    MS-Off Ver
    XP and Windows 7, 8, 8.1
    Posts
    16

    Re: Help with formula to give me a total by month and year end for each driver.

    Thank you very much. It works great as far as I can tell, GREAT JOB!

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Help with formula to give me a total by month and year end for each driver.

    nice to hear it works.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Formula Help - Total Points per driver per year. More complicated than it sounds
    By AnaM21 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2014, 01:36 AM
  2. [SOLVED] How to calculate Year, Month and Day from total number of days?
    By Indra Rai in forum Excel General
    Replies: 4
    Last Post: 06-25-2014, 02:08 PM
  3. how to calculate the total absences within a year per month
    By paularhea09 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2013, 08:32 AM
  4. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  5. Replies: 4
    Last Post: 02-14-2010, 05:21 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