Excel sum column - how to use sum function

Here is a quick tip on how to count total sums for columns or rows. There are many ways for counting sums in Excel, but using the autosum is the easiest, hands down no question.

Sum of row or column in a single cell:

  1. Just click on the cell where you want to display the sum.
  2. Go to the home tab on the ribbon and click autosum from the top right corner.
  3. In the opening dialogue Excel suggests an area to sum up, you can also select a different area if you want.
  4. Click OK and that's it.


Excel sum column - how to use sum function

 

If you want a sum for multiple cells in a row / column:


  1. Select all the cells you wish to display the sums in.
  2. Go to the home tab on the ribbon and click autosum from the top right corner.
  3. In the opening dialogue Excel suggests an area to sum up, you can also select a different area if you want.
  4. Click OK and that's it.

Syntax of SUM function


Manually inserting the SUM function use the following:

=SUM(FIRST CELL:LAST CELL)

Example


Count all the cells from column A.

=SUM(A1:A8)

Count all the cells from column B.

=SUM(B1:B8) 

A1 B1
A2 B2
A3 B3
A4 B4
A5 B5
A6 B6
A7 B7
A8 B8

No comments:

Post a Comment