+ Reply to Thread
Results 1 to 6 of 6

Sum of wages for the year with varying start dates

  1. #1
    Registered User
    Join Date
    02-27-2006
    Location
    Oxford England
    MS-Off Ver
    2007
    Posts
    54

    Sum of wages for the year with varying start dates

    I have a column of months (A) and a column of wages (B) corresponding to the start month of new recruits and their wage.

    How do I sum up the total for the year ?

    Example:
    Start date:Jan in Column A, Wage 100 in Column B
    Start date:Oct in Column A, Wage 150 in Column B

    That would equal a total wage cost in the year of (100*12)+(150*3)=1650

    I cant seem to work out a formula. My months come from a dropdown list, wages are whatever the user types into the cell next to the dropdown list of month.

    Is that clear, or should i give up for Friday ?

  2. #2
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520
    Hi Ainsley,

    Can you attach a sample excel file?
    Corine

  3. #3
    Registered User
    Join Date
    02-27-2006
    Location
    Oxford England
    MS-Off Ver
    2007
    Posts
    54

    Example

    Here is the example. Cheers
    Attached Files Attached Files

  4. #4
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520
    Hi Ainsley,

    Try this formula.

    Please Login or Register  to view this content.
    See the attached xl file for the example. In sheet list of start dates, i added a column, i.e. Jan = 12, Feb = 11 and so on...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-27-2006
    Location
    Oxford England
    MS-Off Ver
    2007
    Posts
    54
    Ah ha, I see, that works well using the Index function.

    Thanks for that, have a good weekend.

  6. #6
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520
    Hi Ainsley,

    Attached file above.

    I'm glad it worked for you.
    Last edited by corinereyes; 10-26-2007 at 12:43 PM.

+ 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