+ Reply to Thread
Results 1 to 3 of 3

Calculate cost per month inlcuding cost of former months

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Calculate cost per month inlcuding cost of former months

    In Row 2 there are the number of months a certain cost should be calculated (number changes every month)
    In Row 3 is the cost at that particular month (cost changes every month)

    I want to calculate the cost for every month but also taking also taken account the costs of former months

    For example in the 1st month the costs are 10 and these are for 5 months, so in the next 5 months 10 cost should be calculated
    In the 2nd month the costs are also 10 but these are for 4 months, so in the next 4 months these costs should be calculated

    I also added an example which will make the question a lot more clear!

    I hope somebody can help me to simplify my excel sheet!

    Thanks!!
    Attached Files Attached Files
    Last edited by keis386; 06-15-2015 at 03:23 PM.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Calculate cost per month inlcuding cost of former months

    Formula in B column , Then drag across.
    Please Login or Register  to view this content.
    ARRAY formula is used

    To enter ARRAY formula
    Paste the formula
    Press F2
    Press Ctrl+Shift+Enter keys together.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: Calculate cost per month inlcuding cost of former months

    Hi
    I have individual 12 formulae for copying across to right.

    B5:
    Please Login or Register  to view this content.
    In C6:

    Please Login or Register  to view this content.
    In D7:

    Please Login or Register  to view this content.
    and so on

    Copy to left as needed

    Regards
    Attached Files Attached Files
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

+ 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. Trying to calculate a pro-rated membership cost based on a day of month
    By damianberry in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2015, 12:47 AM
  2. [SOLVED] How to Calculate the Number of Months From a Given Date and Apply a Monthly Cost
    By sulax in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 06-13-2013, 08:51 AM
  3. Replies: 8
    Last Post: 06-05-2012, 01:16 PM
  4. Calculate the correct cost when more than 1 cost price
    By CplSmudge in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2012, 01:12 PM
  5. Cost Driver calculation - Looking for formula/macro to calculate manpower cost alloca
    By Swastik Banerje in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2009, 11:18 AM

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