+ Reply to Thread
Results 1 to 6 of 6

SUMIFS using Month

  1. #1
    Registered User
    Join Date
    05-14-2016
    Location
    NY
    MS-Off Ver
    2016
    Posts
    2

    SUMIFS using Month

    Hey Guys,

    I am trying to do a SUMIF with multiple criteria from another sheet. I want to sum all rows in a sheet in which it the category matches what I define AND the month matches the month I define. Here is what I have so far...

    =SUMIFS(Register!$D:$D,Register!$C:$C,"Transportation",Register!$A:$A,"MONTH(Register!$A:$A)=6")

    if I remove the MONTH function and specify a specific date that works

    =SUMIFS(Register!$D:$D,Register!$C:$C,"Transportation",Register!$A:$A,"6/15/2015")

    if I try and use a wild card, it does not

    =SUMIFS(Register!$D:$D,Register!$C:$C,"Transportation",Register!$A:$A,"6/15/2015")

    Thanks in advance

  2. #2
    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: SUMIFS using Month

    Hi, welcome to teh forum

    Put your data in it's own cell (say, X1), then use this...
    =SUMIFS(Register!$D:$D,Register!$C:$C,"Transportation",Register!$A:$A,$X$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

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: SUMIFS using Month

    Try
    =SUMIFS(Register!$D:$D,Register!$C:$C,"Transportation",Register!$A:$A,">="&DATE(2015,6,1),Register!$A:$A,"<="&DATE(2015,6,30))

  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: SUMIFS using Month

    Use cells to hold the criteria...

    A1 = Transportation
    B1 = start date like 6/1/2015
    C1 = end date like 6/30/2015

    =SUMIFS(Register!D:D,Register!C:C,A1,Register!A:A,">="&B1,Register!A:A,"<="&C1)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Registered User
    Join Date
    05-14-2016
    Location
    NY
    MS-Off Ver
    2016
    Posts
    2

    Re: SUMIFS using Month

    Quote Originally Posted by Jonmo1 View Post
    Try
    =SUMIFS(Register!$D:$D,Register!$C:$C,"Transportation",Register!$A:$A,">="&DATE(2015,6,1),Register!$A:$A,"<="&DATE(2015,6,30))
    This makes perfect sense but is not working :/

  6. #6
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: SUMIFS using Month

    Well the syntax is correct, no way to tell why it's 'not working' without seeing the data.

    Can you attach a sample book?

+ 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. SumIfs and Month Function
    By pedro90 in forum Excel General
    Replies: 4
    Last Post: 12-29-2014, 08:52 AM
  2. Sumifs with a month
    By pbt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2014, 04:30 PM
  3. [SOLVED] Help with SUMIFS more that one criteria and a month
    By markharris2004 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-25-2014, 05:48 AM
  4. SUMIFS used with month ?
    By spookiepower in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-29-2013, 06:44 AM
  5. Help With SUMIFS by Month
    By dsarkissian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2012, 08:48 PM
  6. Excel 2007 : SUMIFS & month value
    By 78Idyll in forum Excel General
    Replies: 2
    Last Post: 11-22-2011, 05:22 PM
  7. SUMIFS by month/year
    By Lyric in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2011, 02:39 PM

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