Thursday, 27 December 2012

How To Add Numbers - Cells In Excel


    How To Add Numbers Or Cells In Excel

    Microsoft Excel is widely used for Adding numbers or doing  totals , the reason is because it is so very convenient to add numbers in Excel .

    IN this article I will teach you how to add numbers in a  contagious range i.e next to each other using the SUM Formula

  1. If  you want to add numbers which are as shown in the picture



  2. Then you can do so in 3 very simple ways  :)

  3. Use the sum formula and enter the numbers in the sum formula


  4. In this example we can directly type the numbers to be added in the formula itself .

  5.  Refer to the cells containing the numbers in the Sum formula

  6.       In this example we can refer to the address of the cells containing the numbers, into the formula.  We can choose to differentiate the numbers by a "comma ," sign or a (plus + ) sign like shown below . 

                                                         Or



  7. Refer to the range of cells containing the numbers in the formula

  8. If the numbers to be added are next to each other than you can simple select  them as a range.

    You can also see the video tutorial on Sum Formula
    Sum Formula Video Tutorial In Hindi
    Sum Formula Video Tutorial In English 




No comments:

Post a Comment