+ Reply to Thread
Results 1 to 4 of 4

SUMIF per month, overlapping dates

  1. #1
    Registered User
    Join Date
    04-30-2020
    Location
    Sydney
    MS-Off Ver
    google sheet
    Posts
    2

    SUMIF per month, overlapping dates

    Hello Excel community,

    After looking at many forums and tutos I didn't find a way to solve my problem so I would need you help

    I need to summarize my spendings per month for different campaigns I realized during periods of time. The problem is that some campaigns are overlapping between 2 months, for example, from 28/03 to 04/04 which is a problem because I then have to split the spendings of this specific campaign and allocate it to March and April. (you fill find an example in the screenshot attached).

    I thought about doing SUMIFS but I don't know how to write it to make sure that it includes the specific campaigns which were actually in 2 different months.

    I hope I am making myself clear

    Does someone have an idea of how to solve it ?

    Thank you very much in advance for your help !!

    Cheers,
    apo234
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    05-23-2020
    Location
    Guwahati, Assam, India
    MS-Off Ver
    2019
    Posts
    23

    Re: SUMIF per month, overlapping dates

    I have not found out any single formula but had to work out a bit to get what you want. Please see the attached Excel Sheet.
    Attached Files Attached Files
    Asha Kanta Sharma
    Guwahati, India

  3. #3
    Registered User
    Join Date
    04-30-2020
    Location
    Sydney
    MS-Off Ver
    google sheet
    Posts
    2

    Re: SUMIF per month, overlapping dates

    Hi,

    Thank you very much for your answer, it really helped a lot!

    Have a nice day,
    apo234

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,400

    Re: SUMIF per month, overlapping dates

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


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. SUMIF a month name based on a column of dates
    By lorber123 in forum Excel General
    Replies: 3
    Last Post: 06-24-2016, 09:25 PM
  2. Determine if a month falls between two dates - YEARS OVERLAPPING
    By eekbubble in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-18-2015, 12:03 PM
  3. [SOLVED] Sumif/Sumproduct based on Specific dates occurring in any given month
    By Kandy1084 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2015, 03:08 PM
  4. SumIf dates...month & year!
    By RossInk in forum Excel General
    Replies: 4
    Last Post: 04-09-2015, 01:10 PM
  5. Sumif or Index/Match on Multiple Criteria including Dates to Month?
    By patrick1024 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2015, 11:00 PM
  6. Lookup total per month (overlapping dates)
    By IKZOUHETNIETWETEN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-26-2013, 06:00 AM
  7. [Solved] SUMIF based on dates (month)
    By Russell719 in forum Excel General
    Replies: 4
    Last Post: 10-19-2010, 01:30 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