Sum cells depending on number in preceding cell?

Discussion in 'Mac Apps and Mac App Store' started by jent, Nov 20, 2012.

  1. macrumors 6502a

    jent

    Joined:
    Mar 31, 2010
    #1
    I'm trying to develop an Excel spreadsheet that tallies the number of total hours worked on different projects.

    My goal is to be able to enter in a single row the date, the project number, and the number of hours worked on that project. I'm just wondering if it's possible to have Excel look at the "Project number" column, and then assign the number of hours worked in the next column to a tally of total hours worked for that specific project.

    I'm attaching screenshots of what I would want the spreadsheet to look like. The first screenshot would be what I manually type in after each day and project, and the second screenshot would be the automatically summed information.

    Thanks!
     

    Attached Files:

  2. macrumors 65816

    iMacFarlane

    Joined:
    Apr 5, 2012
    Location:
    Phaselocking Psychos somewhere on Pandora
    #2
    Check out the Excel documentation for the SUMIF() function. If that doesn't give you the power you want or need, you may need to learn about array functions, which get ugly fast but really pack a punch with shaping your data as you see fit.
     
  3. macrumors 6502

    prisstratton

    Joined:
    Dec 20, 2011
    Location:
    Winnipeg
    #3
    Something like this:
     

    Attached Files:

  4. thread starter macrumors 6502a

    jent

    Joined:
    Mar 31, 2010

Share This Page