Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Year to date totals in Excel

  1. #1
    Join Date
    10th March 2003
    Posts
    2
    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
    Location
    North Yorkshire
    Posts
    30
    Here is a link to a site created by Rodney Powell Microsoft MVP which has formulas and information about YTD formulas

    http://www.beyondtechnology.com/tips010.shtml

    Hope it helps Graham

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    10th March 2003
    Posts
    2
    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
    Location
    Australia
    Posts
    31,718
    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
    Location
    Derbyshire,UK
    Posts
    18,508
    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
    Location
    London, England
    Posts
    614
    Tami,

    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,
    Chris

  7. #7
    Join Date
    11th March 2003
    Location
    Northern Ireland
    Posts
    2
    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. Text Based On Date Being Year From Current Date
    By Spoony in forum EXCEL HELP
    Replies: 3
    Last Post: April 30th, 2008, 13:23
  2. Excel 2000 incorrectly assumes that the year 1900 is a leap year
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: April 11th, 2008, 15:09
  3. Convert Date To Year/week Of Year/day Of Week
    By Dave196 in forum EXCEL HELP
    Replies: 14
    Last Post: April 7th, 2007, 06:28
  4. convert date field year xx to year xxxx
    By sophism in forum EXCEL HELP
    Replies: 4
    Last Post: January 17th, 2005, 17:34
  5. Date format in Excel (year plus day of year)
    By lynnb0220 in forum EXCEL HELP
    Replies: 1
    Last Post: July 22nd, 2004, 07:23

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
  •  
porno