Help needed regarding excel sheet..

India
January 4, 2010 6:35am CST
hi. i need help regarding excel sheet. i am new to use excel sheet formulas. so please help me out. well, i have a situation where i need to two coloums and return the value in thrid for every row. Example: A B C 1 1 2 2 1 3 3 1 4 like this i have to get the values, so i need the formula so that i can add two coloums and return the value into third coloum... the value in the 3coloum 1st row third cell must return to 1st coloum 2nd row first cell. this proces has to continue for the entire row, plz help me out guys
1 person likes this
1 response
@yelambar (144)
• India
4 Jan 10
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. :)
@yelambar (144)
• India
4 Jan 10
what a mess, formulae in cell c1 will be =a1+b1, c2 will be =a2+b2 and so on.. while cell a2 will be =C1, a3 will be =c2 and so on. am i makes sense?