Loading suggested videos
=SUM(range) where range is the column of numbers you want to add.=SUM(B2:B100))Enter to calculate the total.Result: Excel will add up all the values in the selected range and display the result in your chosen cell.
Tip: You can also use the shortcut Alt + = to auto-insert the SUM function for adjacent cells.
Your feedback helps us improve our content.