+ Reply to Thread
Results 1 to 5 of 5

running total from last 12 months and 90 days from multiple sheets

  1. #1
    Registered User
    Join Date
    08-23-2019
    Location
    Arizona
    MS-Off Ver
    home and student 2016
    Posts
    2

    running total from last 12 months and 90 days from multiple sheets

    I am trying to figure out the formula for a running total from the last 12 months and last 90 days. The data would be coming from previous sheets. So for example I have dates in column A3 down to A29. I have data in cell T34 that I want to keep a rolling total of from the last 12 months and the last 90 days.

  2. #2
    Forum Contributor
    Join Date
    07-01-2018
    Location
    Adelaide, South Australia
    MS-Off Ver
    Office 365, & Excel 2016 on windows 10, & 14.7 for mac, & Excel 2015 for mac
    Posts
    173

    Re: running total from last 12 months and 90 days from multiple sheets

    So you want to run a total on the cells of the current sheet, or of the previous sheet?

    It's not clear what you are asking to reference, or what the format is. Is there a new sheet for each month? If so 3 dimensional references could help.

  3. #3
    Registered User
    Join Date
    08-23-2019
    Location
    Arizona
    MS-Off Ver
    home and student 2016
    Posts
    2

    Re: running total from last 12 months and 90 days from multiple sheets

    i.imgur.com/ypE30sq.jpg

    youll have to go there to see pic. this site is not letting me post links yet.

    I want to keep track of my flight time from the last 12 months and the last 90 days. I want to keep a running total of each cell in row 34. every year we have to submit our last 12 months and last 90 days of flight time to the insurance company.

  4. #4
    Forum Contributor
    Join Date
    07-01-2018
    Location
    Adelaide, South Australia
    MS-Off Ver
    Office 365, & Excel 2016 on windows 10, & 14.7 for mac, & Excel 2015 for mac
    Posts
    173

    Re: running total from last 12 months and 90 days from multiple sheets

    Are you able to post the example file?

    I still have no idea what you are doing with the different sheets as you didn't answer my question, so I'll offer this:

    Option A (for data kept all on the same sheet)
    For 12 months
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    For 90 days change the 365 to a 90.
    Note that you can extend the range areas, but you need to keep the sum range and criteria range (the date) the same size.
    Also note that this formula works for whatever the date is TODAY. You can also swap the TODAY() for a cell reference containing a date you like

    Option B (To pull a total from a range of sheets)
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Note that this formula will choose sheets in the order you have them on your tabs. So if you move PAGE30 past PAGE36 it will be skipped.

    I hope this helps
    Last edited by truk2; 08-26-2019 at 01:05 AM.

  5. #5
    Forum Contributor
    Join Date
    07-01-2018
    Location
    Adelaide, South Australia
    MS-Off Ver
    Office 365, & Excel 2016 on windows 10, & 14.7 for mac, & Excel 2015 for mac
    Posts
    173

    Re: running total from last 12 months and 90 days from multiple sheets

    Did my answer help?
    If it did, please consider the "add rep" star.

    Otherwise let me know if you need more help.

+ 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. 30 Day Running or Rolling total (Multiple Sheets/Workbooks)
    By MuayThaiChick in forum Excel General
    Replies: 3
    Last Post: 02-18-2017, 05:31 PM
  2. [SOLVED] Converting years months and days into into total days
    By Aestivator1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2015, 04:35 PM
  3. Running total of days
    By RainMann in forum Excel General
    Replies: 14
    Last Post: 12-28-2014, 07:09 AM
  4. running total subtract % of previous months
    By amartino44 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-17-2013, 01:42 PM
  5. Replies: 1
    Last Post: 04-13-2013, 05:41 AM
  6. running total from the same field on multiple sheets as i add she
    By obviscator in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2006, 01:40 PM
  7. Fiscal year total from running 12 months
    By in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2005, 09: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