+ Reply to Thread
Results 1 to 6 of 6

SUMIFS(Month) help

  1. #1
    Registered User
    Join Date
    01-07-2021
    Location
    London, Ontario, Canada
    MS-Off Ver
    365
    Posts
    3

    SUMIFS(Month) help

    This should be working but it is not for some reason, and I don't see it.
    Any help is appreciated.

    Please Login or Register  to view this content.
    Table1 has my info
    E4 is the start of month, F4 is the last day of the month
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Dan86F; 01-07-2021 at 10:57 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,600

    Re: SUMIFS(Month) help

    Try this:

    =SUMIFS(Table1[Amount],Table1[Date],">="&E4,Table1[Date],"<="&F4)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    01-07-2021
    Location
    London, Ontario, Canada
    MS-Off Ver
    365
    Posts
    3

    Re: SUMIFS(Month) help

    Thanks AliGW, however that didn't solve it.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,600

    Re: SUMIFS(Month) help

    Works for me on your sample:

    Excel 2016 (Windows) 32 bit
    E
    F
    G
    3
    Month Start Month End Sum
    4
    01/06/2020
    30/06/2020
    $ 135.43
    5
    01/07/2020
    31/07/2020
    $ 419.28
    6
    01/08/2020
    31/08/2020
    $ 388.76
    7
    01/09/2020
    30/09/2020
    $ 342.41
    8
    01/10/2020
    31/10/2020
    $ 294.90
    9
    01/11/2020
    30/11/2020
    $ 285.34
    10
    01/12/2020
    31/12/2020
    $ 118.94
    11
    01/01/2021
    31/01/2021
    $ -
    Sheet: Sheet1

    Excel 2016 (Windows) 32 bit
    G
    4
    =SUMIFS(Table13[Amount],Table13[Date],">="&E4,Table13[Date],"<="&F4)
    Sheet: Sheet1
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-07-2021
    Location
    London, Ontario, Canada
    MS-Off Ver
    365
    Posts
    3

    Re: SUMIFS(Month) help

    Interesting... it is Table13 for some reason, not Table1. that's just odd.

    Working now, Thanks!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,600

    Re: SUMIFS(Month) help

    Yes - that's the name that Excel gave your table when you created it - look at the Name Manager on the Formulas ribbon.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Month-by-month nested Sumifs and AverageIfs formulas stopped working
    By Loyo123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2020, 07:41 PM
  2. [SOLVED] Sumifs with mid corresponding to the month
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2017, 06:01 AM
  3. SUMIFS using Month
    By RadianWear in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2016, 09:23 PM
  4. Sumifs with a month
    By pbt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2014, 04:30 PM
  5. SUMIFS used with month ?
    By spookiepower in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-29-2013, 06:44 AM
  6. Help With SUMIFS by Month
    By dsarkissian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2012, 08:48 PM
  7. Excel 2007 : SUMIFS & month value
    By 78Idyll in forum Excel General
    Replies: 2
    Last Post: 11-22-2011, 05:22 PM

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