+ Reply to Thread
Results 1 to 2 of 2

Rolling calculation

  1. #1
    Registered User
    Join Date
    04-03-2005
    Posts
    58

    Rolling calculation

    I have a sample file attached here. My objective is to get rolling calculation.

    Product A is budgeted for 6 month sales. Against each month actual sales are populated. Assuming we have ended Feb'08, I want to calculate in cell O4, rolling forecast amount which will be actuals upto feb'08 i.e. (50 + 60) + budgeted for March'08 to June'08 i.e.( 70 +70 +75 +75)= 400.

    Basically the command/ string should be dependent on change of month in particular cell , where if I put month end as Jan-08, then rolling forecast will be actuals of Jan'08 + budgeted from Feb'08 to June'08.

    thanks in anticipation

  2. #2
    Registered User
    Join Date
    04-03-2005
    Posts
    58
    sorry forgot the attachment earlier !
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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