Home > Topics > excel > body text

How to sum a series in Excel

angryTom
Release: 2020-02-20 17:13:39
Original
30648 people have browsed it

How to sum a series in Excel

How to sum a sequence in Excel

In Excel, whether it is an arithmetic sequence or a geometric sequence, you can use the following three methods to sum it up .

1. Select a column of numbers, and you will see statistical information such as average, count, and summation appearing in the lower right corner of Excel. The summation result is what you want.

How to sum a series in Excel

How to sum a series in Excel

2. You can also select the numbers you want to sum and click AutoSum directly in the Start menu.

Recommended study: excel basic tutorial

How to sum a series in Excel

The summation result will be obtained at the bottom of the number in the column.

How to sum a series in Excel

3. There is also the formula method. Enter =sum(A1:A6), and you can also get the summation result after pressing Enter.

How to sum a series in Excel

PHP Chinese website, a large number of excel tutorials and Introduction to Programming Tutorials, welcome to learn.         

The above is the detailed content of How to sum a series in Excel. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!