+ Reply to Thread
Results 1 to 1 of 1

Summing multiple sheet range based on column and offset row lookup

  1. #1
    Registered User
    Join Date
    03-25-2005
    Posts
    9

    Summing multiple sheet range based on column and offset row lookup

    My spreadsheet has a sheet for each month. Each sheet has a row for each employee in that month as well as a column for each active project in that month. I would like a summary sheet that: (1) sums the hours for each person per project for the entire year, (2) if possible, maintains the list of employees so they don't have to be copied to the Summary sheet, and (3) if possible, maintains a list of projects so they don't have to be copied to the Summary sheet.

    To make things difficult: Hours are reported by week, so there are multiple lines per person. Not every person exists on every sheet. Not every project exists on every sheet.

    The Summary sheet in the attached example contains hand-calculated values.
    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