Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 7 of 7

Thread: Year to date totals in Excel

  1. #1
    Join Date
    10th March 2003
    I am doing a spread sheet that has about 5 columns and a total. Each month the columns and total will change, but I also need to have a Year to Date column that will continue on each monthly sheet. I have racked my brains and cannot come up with a formula to do this. Can anyone help...fast????:coolwink:

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    25th January 2003
    North Yorkshire
    Here is a link to a site created by Rodney Powell Microsoft MVP which has formulas and information about YTD formulas


    Hope it helps Graham

    Excel Video Tutorials / Excel Dashboards Reports

  3. #3
    Join Date
    10th March 2003
    Thanks Graham, but that is not really what I am looking for. I have a table with 5 different fields and next to each field I have a YTD column. I am going to use this same report each month, but change the amounts in the 5 fields each month, but I need the YTD column to run a continuous total. I don't even know if that makes sense, but that is the best way I can explain what I am looking to do, but I just can't figure out how to do it. If you have any other help, please share.

    Excel Video Tutorials / Excel Dashboards Reports

  4. #4
    Join Date
    24th January 2003
    Hi tamifedrigo

    Welcome to the board

    Have you tried a Pivot Table, or Data>Subtotals? Both of these should do the job depending on your data layout. If you have not used Pivot Tables before see http://www.ozgrid.com/Excel/default.htm and scroll down to Excel Pivot Tables

    You might also consider attaching a copy of your Workbook here so we can see the layout.

  5. #5
    Join Date
    26th January 2003
    To add to Dave's reply. To use a Pivot table you will have to rethink your data recording. All information will have to be on one sheet (database) for your Pivot to read it. Here's a simple layout that might help

    Excel Video Tutorials / Excel Dashboards Reports

  6. #6
    Join Date
    6th February 2003
    London, England

    are you saying you input April's figures and the totals total things up....

    then you replace April's figures with May's figures and you want the cumulative YTD figures to include April AND May ???

    ie.... even though you're effectively overwriting April's figures, you still want the YTD totals to bring themselves in and add themselves to the new May figures

    (if "yes", you're going to need a macro to do this)
    Hope this helps,

  7. #7
    Join Date
    11th March 2003
    Northern Ireland
    I suggest you create another table below your current monthly table which would hold firstly month1, month1+2, month1+2+3,etc. This can be easily done by saying that cell b15 =SUM($B$2:B2). By using copy you can copy the formulae to the other 11 cells. Then create another page using Choose to pick the respective figures for Jan or June. Hope this helps. Drew.

    Excel Video Tutorials / Excel Dashboards Reports

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Date To Year/week Of Year/day Of Week
    By Dave196 in forum Excel General
    Replies: 15
    Last Post: 1 Week Ago, 03:49
  2. Text Based On Date Being Year From Current Date
    By Spoony in forum Excel General
    Replies: 3
    Last Post: April 30th, 2008, 12:23
  3. convert date field year xx to year xxxx
    By sophism in forum Excel General
    Replies: 4
    Last Post: January 17th, 2005, 17:34
  4. Date format in Excel (year plus day of year)
    By lynnb0220 in forum Excel General
    Replies: 1
    Last Post: July 22nd, 2004, 06:23


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts