Summing data by selecting cells in Microsoft Excel


To obtain the sum of the data by selecting range of cells, we can use SUM function to get the output.

SUM: Adds all the numbers in a range of cells

Syntax: =SUM(number1,number2,…)

There can be maximum 255 arguments. Refer below shown screenshot:
Let us take an example:

To take sum of the numbers in column A.

  • The formula in cell A11 would be =SUM(A2:A10)
  • There is another way for doing sum is by pressing ALT + = or click the Auto Sum feature.


To use Auto Sum feature, you need to follow the below mentioned steps:

  • Click on Home ribbon
  • In Editing group, click on AutoSum
  • From drop down list, select Sum


  • You will get the sum of the numbers in range A2:A10


Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>