Need to sum up two columns in Excel 2007

[meright]

Hi, I'm new to Excel programming and I would really appreciate some help on a project I've been working on.

So far I've been doing better than I expected but halfway through the programming I stumbled upon something I don't know how to do.

I have two columns that sum up their own objects (A and B columns) and display it in the last row. now I want a column that sums up the objects of A and B columns and also at the last row sums up all the sums of all A and B cells.

I'd appreciate it if anyone could help me out with this.

Thanks!

 

[jeffreybrown]

Hello & Welcome to the Board,

Are you saying you have something like this?

<TABLE style="WIDTH: 108pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=144><COLGROUP><COL style="WIDTH: 54pt" span=2 width=72><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=21 width=72>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=72>1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=21>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63>2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=21>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63>3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=21>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63> </TD></TR></TBODY></TABLE>

If so, maybe try,

=SUM(LOOKUP(9.99999999999999E+307,A:A),LOOKUP(9.99999999999999E+307,B:B))

 

[meright]

Thanks for the quick reply jeffreybrownhttp://www.mrexcel.com/forum/member.php?u=29987


I should have demonstrated this from the beginning as my wording wasn't clear.



Currently I have this functioning (A - B = C):



<table style="width: 330px; height: 103px;" border="1" cellpadding="0" cellspacing="0"> <tbody><tr height="21"> <td width="72" height="21">2</td> <td width="72">1</td> <td width="134">1</td> </tr> <tr height="21"> <td height="21">5</td> <td>-3</td> <td>8</td> </tr> <tr height="21"> <td height="21">10</td> <td>3</td> <td>7</td> </tr> <tr height="21"> <td height="21">17</td> <td>1
</td> <td>(Not Functioning)</td> </tr> </tbody></table>
I cannot use the sum option for that last cell.

But I want to add the functionality for it to work like this:


<table border="1" cellpadding="0" cellspacing="0"> <tbody><tr height="21"> <td width="72" height="21">2</td> <td width="72">1</td> <td width="134">1</td> </tr> <tr height="21"> <td height="21">5</td> <td>-3</td> <td>8</td> </tr> <tr height="21"> <td height="21">10</td> <td>3</td> <td>7</td> </tr> <tr height="21"> <td height="21">17</td> <td>1
</td> <td>16</td> </tr> </tbody></table>

 

[Xtrimmer]

You can use either:

=A4-B4

OR

=SUM(C1:C3)

 

[meright]

Thanks Xtrimmer, that's exactly what I needed!

 

[Xtrimmer]

Glad to be of some help