+ Reply to Thread
Results 1 to 4 of 4

Sumifs including date range

  1. #1
    Registered User
    Join Date
    12-15-2012
    Location
    vancouver, canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Sumifs including date range

    In the "source data" tab, it shows data by source type by date.

    In the "spend template" tab, I want the source data to total by type based on what's entered in the start date and end date cells (cells B2 and B3).

    I think I should use SUMIFS but I don't know how to incorporate the dates. I have included desired results so you can see what I'd like to do.

    Thanks so much for you help!
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Sumifs including date range

    Maybe this is enough of an example to work with...

    B8 and copy down...
    =SUMIFS('Source Data'!$C$2:$C$18,'Source Data'!$B$2:$B$18,$A8,'Source Data'!$A$2:$A$18,">="&$B$3,'Source Data'!$A$2:$A$18,"<="&$B$4)

    Change the range for the other columns.

    EDIT: On second thought, put this in B8 and copy down and then over to the other columns.

    Please Login or Register  to view this content.
    With this method make sure all of the column headers match.
    Last edited by jeffreybrown; 12-15-2012 at 10:30 PM.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    12-15-2012
    Location
    vancouver, canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Sumifs including date range

    This is great, thanks so much!

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Sumifs including date range

    You are very welcome. Glad to help.

    ==============================

    Please mark as solved if so...

+ 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