How can we help you today?

Search for answers to your questions by entering keywords below, or look through our knowledge base.

Welcome to 'Sikkhon' User Forum

Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users. You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.

Use the SUM function to sum numbers in MS Excel

Un Answered

If you want to sum up a column in Excel and keep the result in your table, you can employ the AutoSum function. the SUM function is easier to use when you’re working with more than a few numbers. It will automatically add up the numbers and will show the total in the cell you select.

For Example:

Here’s a formula that uses cell ranges: =SUM(B2:B6) sums the numbers in ranges. press Enter to get the total of B2->B6

Let's show how to do that quickly and easily.

1 - Select a blank cell in the row below the cells that you want to sum, cell B7 in this example.

2 - Click the AutoSum command on the Ribbon's Home tab

3 - A SUM formula will appear in the active cell. In example =SUM(B2:B6) 

4 - Just press Enter to see the column total.

You can type the SUM function manually like =SUM(B2:B6). It's helpful if you have large ranges for calculation.

The SUM function (syntax) is: SUM(number1, [number2],...).

  • It has one required argument: number1
  • It also has optional arguments, enclosed in square brackets: [number2],..
  • In the example above (=SUM(A1:A4)), there is one argument -- a reference to cells A1:A4.

Need more help? Please give a reply on this post

0 Votes


Login or Sign up to post a comment