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:
 
img1
 
Let us take an example:

To take sum of the numbers in column A.
 
img2
 

  • 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

 
img3
 

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

 
img4
 
 



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>