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?
1. Select cells A1:A5, and you will see the sum results in the status 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.
