+ Reply to Thread
Results 1 to 3 of 3

Sum every other row with multiple conditions including date less than

  1. #1
    Registered User
    Join Date
    02-14-2014
    Location
    Alexandria, VA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Sum every other row with multiple conditions including date less than

    AddEveryOtherColumnIfDateLessThan.png

    I have the attached summary view. I'm looking for a formula that can sum all the values in the hrs column for a particular person and project and for only the dates that are less than or equal to a given date (in cell B9). I've worked out how to sum every other column with the following formula:

    {=SUM(IF(MOD(COLUMN($E3:$R3),2)=1,$E3:$R3,0))}

    but I can't seem to modify it so that it locates a certain person (cell B11) and a certain project (say, cell B8) that is less than or equal to the date in cell B9. Any ideas?

  2. #2
    Registered User
    Join Date
    02-14-2014
    Location
    Alexandria, VA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Sum every other column with multiple conditions including date less than

    testBullet.xlsx

    I've attached the workbook if that helps

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Sum every other row with multiple conditions including date less than

    Try this, copied down and across...
    =SUMIF(OFFSET($A$2,0,4,1,MATCH($B$9,$E$1:$R$1,0)+1),C$10,OFFSET($A$2,MATCH($B11,$A$2:$A$6,0)-1,4,1,MATCH($B$9,$E$1:$R$1,0)+1))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIF by Multiple conditions including calendar month
    By daisiedawn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 04:09 PM
  2. Looking for last entry using multiple criteria including date
    By ayrmad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2013, 11:36 PM
  3. Replies: 5
    Last Post: 05-23-2011, 12:04 PM
  4. sumif: multiple critera including date
    By his5r2m in forum Excel General
    Replies: 3
    Last Post: 05-20-2009, 11:08 AM
  5. multiple lookup including date range
    By JonWadey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2007, 09:21 AM

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