Adding previous cell and current cell functions
20,756
For the sake of an answer:
=SUM(INDIRECT("a1:a"&ROW()))
copied down to suit.
Author by
Structsen
Updated on October 10, 2020Comments
-
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 over 9 yearsthanks, 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