Home  >  Article  >  Topics  >  How to sum a series in Excel

How to sum a series in Excel

angryTom
angryTomOriginal
2020-02-20 17:13:3930609browse

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!

Statement:
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