Results 1 to 3 of 3

Formula for a Moving YTD Total

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-13-2011
    Location
    Yorkshire, UK
    MS-Off Ver
    Office365
    Posts
    183

    Formula for a Moving YTD Total

    Hi, can anyone help me with a formula?

    Looking at the attachment, what I'm trying to do is use the drop down options in cells A2 and A4 to provide moving calculation points for both the current period date and the YTD totals. I've figured out how to do the current period but the YTD is eluding me. I'd like to only calculate the YTD value up to the cell value in A4 i.e if Period 3 is selected it counts periods 1,2 and 3 and if period 6 is selected it counts 1-6 etc etc. The data is pulled from the respective columns on the GRP sheet.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sum Of Moving Annual Total
    By cblp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2015, 09:07 PM
  2. Need help with Moving Annual Total formula by Product, State, and Zip
    By Erica M in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-14-2013, 04:04 PM
  3. Moving Annual Total
    By skate1991 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2013, 01:58 PM
  4. Replies: 2
    Last Post: 10-31-2005, 10:05 PM
  5. Moving total
    By gmoexcel in forum Excel General
    Replies: 2
    Last Post: 05-13-2005, 06:36 PM
  6. Moving total:an input field
    By snn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2005, 06:06 PM
  7. [SOLVED] Having a moving Total
    By Keith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2005, 03:06 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