+ Reply to Thread
Results 1 to 3 of 3

Caclulating the sum between two known intergers assuming constant growth between them

  1. #1
    Registered User
    Join Date
    01-14-2016
    Location
    nottngham, england
    MS-Off Ver
    2010
    Posts
    5

    Unhappy Caclulating the sum between two known intergers assuming constant growth between them

    Hi all,

    This is related to my work (deadline is imminent and help woudl be greatly appreciated!). I imagine there is an easy answer but I have been unable to find it.

    I have traffic counts for two years 2017 and 2032. Assuming a constant growth between these two dates, can i calculate the sum of all the values between these two years (i.e. the total number of vehciles passing during this time period).

    2014 - 17 HGV's
    2032 - 29 HGV's

    2014 - 195 HGV's
    2032 - 396 HGV's

    There is a yearly increase in vehciles between 2017 and 2032. the increase in vehciles in linear growth.
    i want to know the TOTAL number of vehicles on the road between 2017 and 2032.
    I could do this by calculating a yearly increase and making a table then summing the results but that is time consuming and not effective. I would rather use a formula.
    So;
    the formula needs to sum all of the, at present, unknown intergers between the two years.

    the long way is like this:

    2017 17
    2018 29
    2019 41
    2020 53
    2021 65
    2022 77
    2023 89
    2024 101
    2025 113
    2026 125
    2027 137
    2028 149
    2029 161
    2030 173
    2031 185
    2032 197


    Sum of column 2 to get answer = 1712

    But; if I only know the first and last value, is there a quick way to calculate the sum of all the itermediate values without having to write all of it out?

    Thanks

    p.s. thanks to everyone who posts on here, your advice has saved me a number of times (yes that may be a little buttering up but it is true!!)

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Caclulating the sum between two known intergers assuming constant growth between them

    The increase in each year is 12
    So given a year the number of vehicles that year would be

    (year-2017)*12+17
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Caclulating the sum between two known intergers assuming constant growth between them

    Another way:

    Row\Col
    A
    B
    C
    1
    Year
    Count
    2
    2017
    17
    3
    2032
    197
    4
    Total
    1712
    B4: =(A3-A2+1)*(B2+B3)/2


    It's a right trapezoid; the area is the width times the average height.
    Last edited by shg; 01-14-2016 at 12:46 PM.
    Entia non sunt multiplicanda sine necessitate

+ 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. Replies: 7
    Last Post: 01-14-2016, 12:08 PM
  2. Replies: 8
    Last Post: 11-24-2015, 11:32 AM
  3. sales growth vs. headcount growth for recent years
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-15-2015, 04:24 AM
  4. create chart for customer growth vs. expense growth
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-06-2015, 01:19 PM
  5. Random Intergers
    By gregfetzer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-27-2012, 03:03 PM
  6. [SOLVED] Constant growth
    By 050529 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2005, 04:05 PM
  7. Excel 2K - Caclulating a total time.
    By The Admiral in forum Excel General
    Replies: 10
    Last Post: 01-21-2005, 01:06 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