View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
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?