+ Reply to Thread
Results 1 to 4 of 4

Problem with Sumifs

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    N/A
    MS-Off Ver
    Excel 2007
    Posts
    9

    Problem with Sumifs

    I am having a problem with Sumifs where it seems like it's not following the criteria correctly.

    Here is my formula: =SUMIFS(B$2:B$895,A$2:A$895,"<="&$G2,A$2:A$895,"<="&$H2)

    Column A: Dates
    Column B: The data I want to sum
    Column G and H: The criteria dates. I'm trying to do this in year increments so I have 1/1/1997, 1/1/1998...etc. in Column G and 12/31/1997, 12/31/1998 in Column H.

    So what I want is for the formula to add up all the numbers in Column B that fall between 1/1/YYYY and 12/31/YYYY. That's not working tho...

    Thanks in advance for help.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Problem with Sumifs

    In G2 enter: 1/1/1997
    In H2 enter: 12/31/1997

    Then the formula becomes:

    =SUMIFS(B$2:B$895,A$2:A$895,">="&$G2,A$2:A$895,"<="&$H2)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    01-22-2013
    Location
    N/A
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Problem with Sumifs

    Doh! Of course it's something so minor, thanks for the help Tony!

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Problem with Sumifs

    You're welcome. Thanks for the feedback!

+ 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