+ Reply to Thread
Results 1 to 5 of 5

Need help for summing over different dynamic rows

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    Québec
    MS-Off Ver
    Excel 2016
    Posts
    19

    Need help for summing over different dynamic rows

    I am trying to input the interest cost of a loan in a different chart using 3 different scenarios. Each scenarios has a time frame (years) and an interest rate. By example I have a 13 years project, i owe the bank 100 000$. For the first term I have a 4 years at 3.00% fixed rate. In 4 years i'll have a 5 years 3.75% and nine years later a 4.00% for 4 years.


    Years Rate Loan Left Interest Paid during year 1 Interest Paid during year 2 Interest Paid during year 3 Interest Paid during year 4 Interest Paid during year 5
    First Term 4 3.00% 91 235$ 2953$ 2890$ 2824$ 2757$ (empty cell)
    Second Term 5 3.75% 79 791$ 3359$ 3279$ 3195$ 3109$ 3019$
    Third Term 4 4.00% 69 232$ 3120$ 3020$ 2916$ 2807$ (empty cell)


    How it should look.


    Year Cost of Interest
    1 2953$
    2 2890$
    3 2824$
    4 2757$
    5 3359$
    6 3279$
    7 3195$
    8 3109$
    9 3019$
    10 3120$
    11 3020$
    12 2916$
    13 2807$

  2. #2
    Registered User
    Join Date
    03-25-2014
    Location
    Québec
    MS-Off Ver
    Excel 2016
    Posts
    19

    Re: Need help for summing over different dynamic rows

    Added the file. Thank you.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-25-2014
    Location
    Québec
    MS-Off Ver
    Excel 2016
    Posts
    19

    Re: Need help for summing over different dynamic rows

    Anyone has an idea ?

    Thank you.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need help for summing over different dynamic rows

    You add an excel file, and still you have 101 forummembers who have looked at your question.

    None of them replied. That indicates that your question is not clear to the forummembers.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Registered User
    Join Date
    03-25-2014
    Location
    Québec
    MS-Off Ver
    Excel 2016
    Posts
    19

    Re: Need help for summing over different dynamic rows

    Alright, i'll try to better explain what I am trying to do.

    What I am trying to do is that I need a formula that would count the (Q3:U5) table in order ignoring the blank cells and keep counting to the next cell that has a value in it. But what happens, is when I modify the cell I3,I4 and I5 the (Q3:U5) has a completly different pattern.

    I am trying to outputting the (Q3:U5) Table in a yearly table. Either the (I12:J27) or (L13:AA14), which way is the simpler.

+ 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. Summing a row (Dynamic in length)
    By cmb80 in forum Excel General
    Replies: 8
    Last Post: 01-22-2016, 05:22 PM
  2. [SOLVED] Help with Summing Duplicates, deleting rows after summing and filling col. for unsummed
    By solidrock1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 09:11 AM
  3. [SOLVED] Dynamic summing of columns based on variable rows and dates
    By Swept in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2013, 01:33 PM
  4. summing dynamic ranges
    By Alan M in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2006, 11:20 AM
  5. Summing with Dynamic Data
    By waynehinds in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2006, 07:28 PM
  6. dynamic summing of an autofilter 'ed table
    By john boy in forum Excel General
    Replies: 4
    Last Post: 05-19-2005, 01:07 AM
  7. Summing multiple dynamic ranges
    By ANDYGM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2005, 05:48 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