+ Reply to Thread
Results 1 to 3 of 3

12 month sum based on current date

  1. #1
    Registered User
    Join Date
    01-21-2017
    Location
    East Tawas, Michigan
    MS-Off Ver
    Office 2013
    Posts
    25

    12 month sum based on current date

    Hello, I have a file in which i am trying to keep a current 12 month sum of forecast values. Essentially if it is April of 2018 i want it to forecast the sum for the following 12 months as well and when a new month occurs it automatically switch to the current month and sum the new out month forecast for the next 12 as well. In the attached Columns "C" and "I" would be the columns to be summed.
    Attached Images Attached Images

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: 12 month sum based on current date

    Something like this:

    =SUMIFS($C$8:$C$30,$A$8:$A$30,">"&DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),$A$8:$A$30,"<"&DATE(YEAR(TODAY()),MONTH(TODAY())+13,1))

    But your months should be actual dates like 1-01-2018 and formated as dd-mmmm-yyyy

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,459

    Re: 12 month sum based on current date

    Try 2 SUMPRODUCT, one for this and another for next year:

    Please Login or Register  to view this content.
    Quang PT

+ 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. flexible update of remaining amount and end date based on current month
    By k1dr0ck in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-05-2015, 03:09 AM
  2. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  3. [SOLVED] Pick a cell containing current month actulas based what the current month is.
    By vanbasten007 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-10-2014, 01:17 AM
  4. [SOLVED] Date Formula to Return Week Number in Current Month based on Reporting Period
    By jeversf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 12:10 PM
  5. Replies: 1
    Last Post: 08-13-2012, 11:18 AM
  6. [SOLVED] VBA to identify the current month and previous month based on system date
    By ravikumar00008 in forum Excel General
    Replies: 10
    Last Post: 07-26-2012, 10:04 AM
  7. Current date formula based on month
    By Renz09 in forum Excel General
    Replies: 2
    Last Post: 05-05-2006, 02:04 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