Calculation method of accumulation and superposition of Excel

Source: Internet
Author: User
Tags relative

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

Related Keywords:
Related Article E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth \$300-1200 USD