top of page

Sum a column in Microsoft Excel

1. Open your excel worksheet containing the data or enter the desired data, say, the budget of an individual.

2. Go to the cell wherever you want the sum to be and type "=Sum(" and then click on the cell from where you want your sum to start.

3. Then type "=Sum(B2:" and then click on the last entry till where you want the sum.

4. Then close the bracket. It will be shown as "=SUM(B2:B6)".

5. Hit enter an you will get the sum.

40 views0 comments

Recent Posts

See All


bottom of page