Thread: [SOLVED] Adding two Coloumns in Excel 2007

Hey all,

This might be way below the average mathematical discussion level at this forum but I do need help and the people here seem to know a crap load.
I am using Excel 2007 and i need to add values in cells between two coloumns with the output in a third coloumn in the same correspondig cell, Here's an example:

Coloumn A Coloumn B Coloumn C
1 2 ?
4 5 ?
4 6 ?
5 7 ?

Basically I would like to add the values in each cell of A and B and have the output in the corresponding cell in C, eg - 1 (A) + 2(B) = 3(C)

I would appreciate help with this.

Thanks

Originally Posted by jreddi

Hey all,

This might be way below the average mathematical discussion level at this forum but I do need help and the people here seem to know a crap load.
I am using Excel 2007 and i need to add values in cells between two coloumns with the output in a third coloumn in the same correspondig cell, Here's an example:

Coloumn A Coloumn B Coloumn C
1 2 ?
4 5 ?
4 6 ?
5 7 ?

Basically I would like to add the values in each cell of A and B and have the output in the corresponding cell in C, eg - 1 (A) + 2(B) = 3(C)

I would appreciate help with this.

Thanks

Select first cell in column C that you want.

Now in the formula bar type "=" then select the cell in column A which will enter the cell reference after the "=". Now type "+" after the cell reference, and now select the correct cell in colum B (which will enter the cell reference into the formula).

Now click on the gree tick in the green tick in the formula bar and the total should appear in the first cell in column C.

Select the cell that we have just entered the formula in and right click. From the menu select copy.

Select the range of column C that you want the totals, right click and select paste and you are done.

RonL