+ Reply to Thread
Results 1 to 3 of 3

YTD Total Minus Previous Month

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    Shippensburg, PA
    MS-Off Ver
    Excel 2010
    Posts
    5

    YTD Total Minus Previous Month

    I can't seem to wrap my head around how to accomplish this. I have a year-to-date running total with all the months listed. It keeps a running total anytime a new number is added. What I would like to do is have a separate cell that gives me the running total minus the previous month and would update automatically each time a new value is entered.

    This is how it should look with Feb being filled out at the end of the month so I would then want a previous month cell to give me the totals of Nov-13 - Jan 14 and my YTD will give me the totals of Nov-13 - Feb-14.
    Month Monthly Total
    Nov-13 136676
    Dec-13 140085
    Jan-14 122142
    Feb-14 0
    Mar-14 0
    Apr-14 0
    May-14 0
    Jun-14 0
    Jul-14 0
    Aug-14 0
    Sep-14 0
    Oct-14 0
    Nov-14 0
    Dec-14 0
    YTD 122142

    It seems like it should be simple but I just can't figure out how to accomplish it or maybe its not a possible function.

  2. #2
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: YTD Total Minus Previous Month

    Hi,

    Use the following formula.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Like my answer, then click * below

  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    Shippensburg, PA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: YTD Total Minus Previous Month

    This works until more information is added. If numbers are added for February, it gives the new total, but the previous month doesn't update. Is this possible to do?

+ 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] Formula for amount on previous month based on current month
    By Yu Marquez in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-21-2014, 12:42 AM
  2. Macro using vlookups comparing 2 months paysheet(previous month and current month)
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2012, 03:45 AM
  3. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  4. [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
  5. Replies: 4
    Last Post: 03-19-2012, 08:58 AM

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