Excel Basics

Adding two numbers in Excel is very easy.

e.g. You want to add two number.

1st number 2

2nd number 3

Now select any cell.....for example select Cell no B3. After selecting the cell click on the Formula bar. (It should be just below of your tool bar.

You can see a "fx" written just before it..its a long blank place.)

Type this in the Formula Bar "= 2+3"

When you press enter or press tab button you will see the exact value for the addition of those numbers. In this case it will be 5.

You can do this by auto-sum key. This key situated in your Tool bar. It looks like this :-

----
\
/
----


Step to add two or more numbers using auto-sum.

Just enter your desired numbers in a range of cells. Now, when you finished with entering numbers in the cells then just select the cell where you want to display your sum result and click on that specific auto-sum icon in the tool bar.

Just after clicking on that icon a range of cell will be automatically selected. You can now manually drag or change the range of the selected cells (suppose the automatically selected range is from B3 to D5 but you want it from B3 to C8. Just select it manually and selection rules are as same as in others.).

When you finished with your selection. Just hit enter. The result will appear in your desired cell automatically.

Adding value of two different Cell

Suppose you want to add values of Cell no B3 and Cell no D4. and you also want to display the result in the Cell no E5. Now, double click on the cell no E5 or you can also select the cell E5 and then go to Formula bar. After double clicking or pointing to Formula bar just type this formula:-

=sum(b3+d4)

After entering this into formula bar hit enter. From now, whenever your put a value in those cells you will be automatically shown their sum in the cell no E5.

Do not forget to type the Equal sign "=". If you dont give an equal sign before an formula then it will not work as a formula. Also remove the double inverted comma from the 1st formula.