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 Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

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

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.