functions

[Guest]

I have 2 columns. I want to add the two numbers together and have the total
put in a third column.Also have a total at the bottom of the 1st column & 3rd
column.
Like this: 1 + 1= 2
1 + 1= 2
1 + 1= 2

 

[Gord Dibben]

In C1 enter =A1 + B1 and drag/copy down to C3.

In A4 enter =SUM(A1:A3) or highlight A1:A4 and hit the SUM(sideways M)
button on Toolbar.

Copy to C4

Adjust columns and cell references to suit.

Gord Dibben Excel MVP

 

[Myrna Larson]

=A1+B1
=A2+B2
=A3+B3

=A1+A2+A3 or =SUM(A1:A3)
=C1+C2+C3 or =SUM(C1:C3)

 

[Dana DeLouis]

Another idea. Assuming your example data is A1:B3 with surrounding blank
cells.
Select A1:C3, then hold the Ctrl key and select A4 and C4.
Click the AutoSum button.

The AutoSum button prefers to Sum horizontally, but you prefer the lower
right corner cell to sum vertically by removing the sum in B4.
HTH.