Home>Article>Topics> How to sum a column of data in excel

How to sum a column of data in excel

藏色散人
藏色散人 Original
2020-09-12 11:39:05 117749browse

How to sum a column of data in excel: first open an excel table data; then select a column of data; finally click the [Automatic Sum] option in the toolbar options with the mouse.

How to sum a column of data in excel

Recommendation: "Excel Tutorial"

Method:

1. Use "Automatic Find and". Steps: Select this column of data and click "AutoSum" in "Toolbar Options".

How to sum a column of data in excel

#2. Use functions to find the sum. As in the above example, the formula A7=sum(a1:a6)

3, use addition formula to find the sum. As in the above example, the formula A7=a1 a2 a3 a4 a5 a6

The above is the detailed content of How to sum a column of data 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