Adding previous cell and current cell functions

20,756

For the sake of an answer:

=SUM(INDIRECT("a1:a"&ROW()))

copied down to suit.

Share:
20,756
Structsen
Author by

Structsen

Updated on October 10, 2020

Comments

  • Structsen
    Structsen over 3 years

    I like to have an Excel Function for:

     Previous cell + Current Cell  = Current cell  
    

    to do this function for the entire row, when I enter a new value each time, Eg. A1+A2= A2.

  • Structsen
    Structsen over 9 years
    thanks, But my problem is the excel has add the cell it does for individual cell, Input are 0 1 2 3 4 5 and output are 1 3 6 10 15