Help needed regarding excel sheet..  

if i understood you correctly try this..
A B C
1 1 1 =A1+B1
2 =C1 1 =A2+B2
3 =C2 1 =a3+b3

and so on. You can just enter the formula once in cell C1, once done you can then drag the cell down, it will copy all the formula's, same goes for cell A2.

Hope this helps, if you have more questions please let me know.

:)

I been using excel for more than 12yrs now and I've already mastered how the formula works but i can't understand what you trying to do or to say may be it would be better if you will make a screen shots of your excel then maybe I could help you.

Hello Ananth,

You want to add the first column and second column values?
For formula just do this:

=SUM(B2+C2)Here B2 and C2 are the Cell names in which the values are entered. Usually you get the answer in D2 or whatever cell you choose.

and after that click the "Enter" button. You can also just 'copy' the D2 cell that gives you the answer of the operation and paste it into all other cells for which you want to do the same operations like E2, F2 etc.

You can use the formula for other operations but you need to change the "+" to whatever operation you want like "-" or "*" "/"

These are the simple mathematical operations. For complex operations you need to follow some different formulae. You can get that in excel sheet only. Or follow any article or book on that.

Hope this helps you.

Happy Mylotting!

I really don't understand what you want to get on column C...
The example you give is not helping at all...
Maybe if you arrange the figures just as they appear on the excel sheet.. like this
A B C
1 1 2
2 1 3
3 1 4
Is this how the figures must appear?
If I understand correctly, column C must contain the sum between column A and column B.
To do that, click on the first cell of column C, and type =A1+B1
After you hit ENTER, you will see that the value is the sum between A and B. Please be careful, if you have given titles to each column, and you have something like:
A B C
"First" "Second" "Sum"
1 1 2
2 1 3
3 1 4

you will have to type in =A2+B2
Because A1, B1 and C1 contain characters, not numbers.

After typing the formula for C, to extend it for the entire column, you need to put your mouse on the lower right corner of the cell in which you typed the formula, and drag it down for as many other cells you need.

I hope this helps...