+ Reply to Thread
Results 1 to 2 of 2

Running totals based off monthly

  1. #1
    Registered User
    Join Date
    11-29-2017
    Location
    Clearwater, FL
    MS-Off Ver
    2016
    Posts
    47

    Running totals based off monthly

    In my workbook I have a sheet named "TSA Dashboard"

    In Cells C4:J10 it the total for our team. In Cells A13:J49 is each persons individual stats for the week. The dates automatically change based on the date. In Cell L1:R11, I have a month to date chart. I would like for at the end of the week, it will add all of the weekly data to the totals in L1:R11. If I need a button to do that I can but it is a running total till the end of the month, then i want it to reset for the next month! Is this possible? I have an example uploaded so you can see what I am talking about!
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Running totals based off monthly

    OK to save me wading through this, which table is the data table, and which 1 is your "answers"? (and what is the 3rd doing?)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 11
    Last Post: 08-12-2015, 01:38 PM
  2. Create calendar with running monthly/weekly totals and averages
    By ecp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-12-2014, 04:27 PM
  3. Create calendar with running monthly/weekly totals and averages
    By ecp in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-09-2014, 05:01 PM
  4. Replies: 3
    Last Post: 02-12-2011, 12:10 PM
  5. Running Monthly Totals
    By Sionos in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-26-2010, 06:04 PM
  6. Running Monthly Totals on Multiple Sheets
    By Dragunov in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-29-2007, 12:57 AM
  7. How do I sum YTD totals based on monthly totals
    By Bsgrad02 in forum Excel General
    Replies: 3
    Last Post: 07-12-2005, 12:05 PM

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