Skip to main content

How to Sum Data in Excel

There are many ways to sum data in an Excel spreadsheet. For example, if you want to sum the values in cells A1:A5, how to do it?

How to Sum Data in Excel

1. Select cells A1:A5, and you will see the sum results in the status bar.

Sum Stats Bar

2. Select cells A1:A5, press and hold ALT, then press =, Excel will auto display the sum in cell A6.

3. Select cell A6, press and hold ALT, then press =, Excel will auto select cells A1:A5, and auto insert the formula: =SUM(A1:A5), you can change the reference, and press ENTER to end this.


4. Select cell A6, then enter the formula: =SUM(A1:A5), then press ENTER.

5. Select cell A6, then click Formulas tab, in Function Library group, click AutoSum button.

Excel AutoSum Toolbar

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>