+ Reply to Thread
Results 1 to 2 of 2

To generate a sequence of summation

  1. #1
    Registered User
    Join Date
    03-15-2020
    Location
    Sydney, Australia
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    17

    To generate a sequence of summation

    Hi All,

    I wanted to generate a formula for sum of values, but not a direct sum. For the first row it should be equivalent to the value in the amount, for the second it should be the sum of values in 2nd and 3rd row and so on. I have attached a set of data and the expected output as well.

    Please look into it and help me on this.

    Thanks & regards,
    Snehith
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-22-2020
    Location
    Malaysia
    MS-Off Ver
    2013 and 365 Pro Plus
    Posts
    56

    Re: To generate a sequence of summation

    Quote Originally Posted by Snehith Moturi View Post
    Hi All,

    I wanted to generate a formula for sum of values, but not a direct sum. For the first row it should be equivalent to the value in the amount, for the second it should be the sum of values in 2nd and 3rd row and so on. I have attached a set of data and the expected output as well.

    Please look into it and help me on this.

    Thanks & regards,
    Snehith
    at cell D2

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag the formula down

    Explanation

    If reference cell is equal to 1, 6, 7 or 8 row, return same value
    If reference cell is equal to 3 or 5 row, value above reference + reference
    else reference + value below reference

    im sure someone will come and have better solution
    Attached Files Attached Files
    Last edited by biex; 04-08-2020 at 09:32 PM.

+ 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. [SOLVED] How to generate a repeating text sequence
    By FrankL0 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-01-2019, 02:45 PM
  2. excel generate a sequence of whole number e.g. 1 2 3
    By LEEDA12345 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2014, 01:47 PM
  3. How to auto generate sequence number
    By FelicityCSaycon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-13-2013, 08:38 AM
  4. To generate numbers in sequence using vba code
    By Sriram Anand in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2012, 12:35 PM
  5. [SOLVED] Need formula to generate sequence
    By singhabhijitkumar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-24-2012, 03:46 AM
  6. Excel 2007 : Generate a numerical sequence in one cell
    By Cushionsupplier in forum Excel General
    Replies: 2
    Last Post: 03-21-2010, 06:58 PM
  7. [SOLVED] generate sequence of number
    By cyzax7 via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2006, 04:00 AM

Tags for this Thread

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