+ Reply to Thread
Results 1 to 2 of 2

Sumproduct with 5 criteria

  1. #1
    Registered User
    Join Date
    05-28-2007
    Posts
    2

    Sumproduct with 5 criteria

    I've attached a zip file to hopefully make it easier to explain this.

    On the variable tab you can see the from and to dates for each month (basically the start and end dates for each month)

    On the DataEntry#2 tab you will see projects by rows (you can have the same project more then once - on multiple roles), with contract signed as a Y/N, the price (an hourly rate), and then the number of hours per week in columns S through AF.

    What I need to do is sum up the total revenue per month (using the from/to dates) for each project (sum across the potentially multiple roles), and differentiate if the contract is signed or not.

    The aggregated $ amount is posted on the DataEntry #1 tab (I have highlighted one such cell in Blue under the Backlog title - column AR). This would be all revenue in June for project 001 that has a contract signed (Backlog).

    Your help would be greatly appreciated.

    Jeff
    Attached Files Attached Files
    Last edited by jeffg; 05-28-2007 at 05:00 PM.

  2. #2
    Registered User
    Join Date
    05-28-2007
    Posts
    2

    Sum The Total Hours By Project Between Two Dates

    Here is a simplified description of the issue:

    Hi,

    I need to sum the total hours by project between two dates. There can be multiple projects and the two dates can vary. So...

    In column A are the project # (say A2 001, A3 001, A4 002, A5 003)
    In column B is Yes or No for each project (contract Signed?)
    In Column C through Z, row 1, are dates (shows the Monday of each week)
    In Column C through Z, row 2-5 (which corresponds to the projects 001, 001, 002, and 003 above) are the number of hours worked that week.

    On a separate tab (lets call it MonthTab) is the start and end date for each month (Jan through Dec)
    On a separate tab I want to SUM the hours by Month for each project (so for project 001 would need to go across multiple rows), that has a Yes in column two. Therefore the hours summed For January will be taken from MonthTab and be between StartJan and EndJan.

    Jeff

+ 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