Excel shortcuts

10 shortcuts for sum in excel

If you work with Microsoft Excel on a regular basis, you know that there are many different ways to sum numbers. You can use the SUM function, or you can use a shortcut. In this article, we'll show you 10 different shortcuts that you can use to sum numbers in Excel.

1. Use the AutoSum feature

One of the quickest and easiest ways to sum numbers in Excel is to use the AutoSum feature. Simply select the cells that you want to sum, and then click the AutoSum button on the Home tab. Excel will automatically insert the SUM function for you.

2. Use the SUM function

If you want more control over the cells that are being summed, you can use the SUM function. To use the SUM function, simply type =SUM( into a cell, and then select the cells that you want to sum. Excel will automatically insert the closing parenthesis for you.

3. Use a shortcut

If you know the shortcut for the SUM function, you can save yourself a few keystrokes. To sum a range of cells, simply select the cells, and then press Alt + =. Excel will automatically insert the SUM function for you.

4. Use the fill handle

Another quick and easy way to sum numbers in Excel is to use the fill handle. Simply select the cell that contains the SUM function, and then drag the fill handle down to the cells that you want to sum. Excel will automatically update the SUM function for you.

5. Use a named range

If you want to sum a range of cells that is not adjacent, you can use a named range. To use a named range, simply select the cells that you want to sum, and then give the range a name. To sum the named range, simply type =SUM( into a cell, and then type the name of the range. Excel will automatically insert the closing parenthesis for you.

6. Use a table

If you're working with a table of data, you can use the SUM function to sum the data in the table. To use the SUM function with a table, simply select the cells that you want to sum, and then press Alt + =. Excel will automatically insert the SUM function for you.

7. Use an array

If you want to sum a range of cells that is not adjacent, you can use an array. To use an array, simply select the cells that you want to sum, and then press Ctrl + Shift + Enter. Excel will automatically insert the SUM function for you.

8. Use a PivotTable

If you have a lot of data, you can use a PivotTable to sum the data. To use a PivotTable, simply select the cells that you want to sum, and then click the Insert tab. In the Tables group, click PivotTable. Excel will automatically insert a PivotTable for you.

9. Use the SUBTOTAL function

If you want to sum only the visible cells in a range, you can use the SUBTOTAL function. To use the SUBTOTAL function, simply type =SUBTOTAL( into a cell, and then select the cells that you want to sum. Excel will automatically insert the closing parenthesis for you.

10. Use the AGGREGATE function

If you want to sum only the visible cells in a range, you can use the AGGREGATE function. To use the AGGREGATE function, simply type =AGGREGATE( into a cell, and then select the cells that you want to sum. Excel will automatically insert the closing parenthesis for you.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.