Excel vertical column automatic summation

Excel vertical column automatic summation

1. Select the columns that require and.

2. In the menu bar, click the Formula option.

3. Select the "automatic summation" function.

If you need to sum several consecutive columns, you can first select the first column, then hold down the Shift key and drag the mouse to the end of the required column.