Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 447
Default 90 day Running total

I have a workbook set-up that contains two worksheets. One work sheet has the
current date and totals for individual inventory. The second worksheet has
the individual months with that months inventory. How do I set a formula in
the first sheet that will calculate the running total for the last 90 days
and automatically generate new totals when the date is changed on workeet 1?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,180
Default 90 day Running total

Excel 2007 PivotTable
Running totals for last 3 months.
With macro.
http://c0444202.cdn.cloudfiles.racks.../01_20_10.xlsm

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Total open a adobe file from a command button Excel Worksheet Functions 7 April 21st 09 02:16 PM
Duplicate Running Total Grand Total In Pivot Table Mathew P Bennett[_2_] Excel Discussion (Misc queries) 1 August 17th 08 03:13 AM
running total and average of that total after 3 events belvy123 Excel Discussion (Misc queries) 0 March 28th 07 02:57 AM
running total and average of that total after 3 events Toppers Excel Discussion (Misc queries) 1 March 28th 07 02:19 AM
running total D.J.Shaw Excel Worksheet Functions 1 July 8th 05 11:38 AM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"