+ Reply to Thread
Results 1 to 1 of 1

Formula for Consolidating Array Values from a Column & Calculating Corresponding Cells

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Smile Formula for Consolidating Array Values from a Column & Calculating Corresponding Cells

    Please help. I've created a form in google docs spreadsheets for employees to enter information into a daily time sheet record that is visible to administrative staff only once entered. The names entered into the form will not be fixed (we've got independent contractors across CA) but since the information will be recorded daily the spreadsheet will have multiple entries by any given employee per day for every calendar month.

    What I need to do is the following:

    Match entries on "Sheet 4" Column A with the same names in column, total the number of hours & pay that are corresponding in Columns B & C, and re-list in 4 new Columns. All corresponding to each other, one by Name (representing only one name entry per month in new column #1), by dates (dates for one month all included in one cell & new row/cell for another month in new column #2, total hours calculated per month (in new column #3, and total pay calculated per month (in new column #4).

    Example:

    New Col #1.....New Column #2.....New Column #3.......New Column #4
    Tom Hanks......9/2,9/3, 9,10,.......20hrs....................$300
    Tom Hanks......8/1, 8/4. 8/30,......40hrs....................$600
    Collin Hanks....9/4, 9/6, 9/30,.......100hrs..................$1,000
    R.Williams.......6/4, 6/5, 6,15,.......25hrs....................$400
    R.Williams.......9/1, 9/15, 9/21,.....80hrs....................$2,500

    See attachment for details.

    Any help someone could give on this would be awesome!!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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