Help needed regarding excel sheet..
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
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. :)