First, let's take a look at what is additive and superposition.
Introduction to the theory of accumulation and superposition
Look at the picture below.
Column B, which holds the original data. Now, what we're going to achieve is:
C1=b1
C2=c1+b2
C3=c2+b3
C4=c3+b4
......
And so on, to implement this method of calculation, this form of addition, is called additive or superposition.
Two methods of realizing superposition and accumulation
① Formula method
Look at the diagram below, first of all, using the sum formula is easy to implement.
As shown above, the C1 formula is: =sum (B$1:B1)
Then, using the fill function to pull down, you can add and accumulate, and so, it becomes:
C2 formula into: =sum (B$1:B2)
C3 formula into: =sum (B$1:B3)
C4 formula into: =sum (B$1:B4)
C5 formula into: =sum (B$1:B5)
......
So
Note that b$1 refers to an absolute reference, where it refers to an absolute reference row and a relative reference column. If you want to know what absolute references and relative references are, please refer to the keyword "absolute reference" in this site to find the article.
② Direct calculation method
Using formulas in C1: =B1
Using formulas in C2: =B2+C1
Use the Fill function from the C2 cell to pull down, then it will become:
C3=c2+b3
C4=c3+b4
......
So