How to Add Up Columns in Excel
Launch your file on Excel., Select a cell., Type in a summation statement in the cell.
Step-by-Step Guide
-
Step 1: Launch your file on Excel.
Select your desired spreadsheet file and open it in Microsoft Excel. -
Step 2: Select a cell.
You will need to select a cell where you want the summation to be displayed.
It could be at the bottom of a column where you can total the values in the column. , Click on the cell you selected.
On the text bar at the top (where the text in the cell is displayed) type in =SUM(AX:
AY).
Where the variable A is the letter of the row you desire, X being the variable of the cell you want to begin summation, and Y being the last cell in your summation -
Step 3: Type in a summation statement in the cell.
Detailed Guide
Select your desired spreadsheet file and open it in Microsoft Excel.
You will need to select a cell where you want the summation to be displayed.
It could be at the bottom of a column where you can total the values in the column. , Click on the cell you selected.
On the text bar at the top (where the text in the cell is displayed) type in =SUM(AX:
AY).
Where the variable A is the letter of the row you desire, X being the variable of the cell you want to begin summation, and Y being the last cell in your summation
About the Author
Anthony Roberts
Professional writer focused on creating easy-to-follow hobbies tutorials.
Rate This Guide
How helpful was this guide? Click to rate: