Results 1 to 7 of 7

Monthly Tmesheet - Sum-Find-Between 2 Dates-&-2 Tables

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,059

    Question Monthly Tmesheet - Sum-Find-Between 2 Dates-&-2 Tables

    Hi,

    This question is partially associated with my original question, stated within: Nest / Combine 2 Sumproduct Functions from 2 Different Tables post, but now a new question or variation to it has been added

    I attached a Similar To example of my Monthly Timesheet:

    I'm creating a monthly timesheet & have a list of projects below time timesheet - Cells: D60:D69.

    Starting at Cell: J60 - Downward - Using the following function, which finds / matches various projects from the 2 above tables & sums up cumulative totals, using:

    =IF($C$12="","",SUMPRODUCT(--($C$12:$C$17=C60),--($T$12:$T$17)))--IF($C$22="","",SUMPRODUCT(--($C$22:$C$36=C60),--($T$22:$T$36)))
    (Provided by: ben_hensel)


    Now, through Cells, D60 though H69, seeking to use similar intent or function as above, except to find cumulative total hours per specified projects & during specified dates as stated through Cells, D57 through H58 between the 2 tables (1st Half of Month & 2nd Half of Month)

    Please see attached example

    Thanks
    Attached Files Attached Files
    MyCon
    -- Using Latest Version of Excel

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Converting monthly dates to quarterly dates
    By kirby5050 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-04-2014, 12:40 AM
  2. Access Used to Find, Tabulate and Sum Numbers by Monthly Dates
    By Doc Snowfox in forum Access Tables & Databases
    Replies: 19
    Last Post: 07-12-2013, 05:44 PM
  3. Replies: 6
    Last Post: 03-11-2013, 06:11 PM
  4. Find months between start and end dates and multiple the monthly revenue
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2013, 05:22 PM
  5. Is It Possible To Find/Replace Dates In Pivot Tables and Cell Formulas?
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2012, 03:37 AM

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