+ Reply to Thread
Results 1 to 2 of 2

Problem with SUMIFS by Month Formula

  1. #1
    Registered User
    Join Date
    07-16-2017
    Location
    toronto
    MS-Off Ver
    2016
    Posts
    3

    Problem with SUMIFS by Month Formula

    Can you please advise what is wrong with this formula? It is currently returning an error?

    =SUMIFS(Data!$K$2:$K$21,Month(Data!I2:I21),"="&MONTH(J7))

    K2:K21 are the amounts
    I2:I21 are the dates
    J7 is the date from which I want to use the month to return the sum of matching amounts.

    Pls advise.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Problem with SUMIFS by Month Formula

    Try:

    =SUMIFS(Data!$K$2:$K$21,Data!I2:I21,">"&EOMONTH(J7,-1),Data!I2:I21,"<="&EOMONTH(J7,0))

+ 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] Dynamic month and year criteria in Sumifs formula
    By 4gurus in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-19-2016, 08:19 AM
  2. Replies: 10
    Last Post: 02-25-2015, 05:08 PM
  3. [SOLVED] SUMIFS Formula Problem
    By AlexMillington in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-28-2014, 01:54 PM
  4. SUMIFS Formula Help - Attendance sum per month
    By jpoppet in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-06-2013, 10:13 AM
  5. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  6. Add values based on month using Sumifs or any other formula
    By ktmjamal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-18-2012, 05:23 AM
  7. sumifs (i think) formula problem
    By big_nath in forum Excel General
    Replies: 2
    Last Post: 09-30-2011, 09:58 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