If your worksheet looks like this
<b>Sheet1 (2)</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-style
utset;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-style
utset;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-style
utset;border-color:#f0f0f0; ">C</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; ">X</td><td style="background-color:#ffff00; text-align:right; ">53</td><td style="background-color:#ffff00; text-align:right; ">71</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffff00; ">N</td><td style="background-color:#ffff00; text-align:right; ">43</td><td style="background-color:#ffff00; text-align:right; ">1</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ffff00; ">X</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">15</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ffff00; ">N</td><td style="background-color:#ffff00; text-align:right; ">49</td><td style="background-color:#ffff00; text-align:right; ">93</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; "> </td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ffcc00; ">L</td><td style="background-color:#ffcc00; text-align:right; ">12</td><td style="background-color:#ffcc00; text-align:right; ">68</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ffcc00; ">O</td><td style="background-color:#ffcc00; text-align:right; ">42</td><td style="background-color:#ffcc00; text-align:right; ">20</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ffcc00; ">O</td><td style="background-color:#ffcc00; text-align:right; ">12</td><td style="background-color:#ffcc00; text-align:right; ">85</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ffcc00; ">D</td><td style="background-color:#ffcc00; text-align:right; ">59</td><td style="background-color:#ffcc00; text-align:right; ">82</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ffcc00; ">W</td><td style="background-color:#ffcc00; text-align:right; ">55</td><td style="background-color:#ffcc00; text-align:right; ">33</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ffcc00; ">H</td><td style="background-color:#ffcc00; text-align:right; ">24</td><td style="background-color:#ffcc00; text-align:right; ">50</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ffcc00; ">J</td><td style="background-color:#ffcc00; text-align:right; ">76</td><td style="background-color:#ffcc00; text-align:right; ">72</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ffcc00; ">W</td><td style="background-color:#ffcc00; text-align:right; ">3</td><td style="background-color:#ffcc00; text-align:right; ">22</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ffcc00; ">D</td><td style="background-color:#ffcc00; text-align:right; ">87</td><td style="background-color:#ffcc00; text-align:right; ">5</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#ffcc00; ">I</td><td style="background-color:#ffcc00; text-align:right; ">8</td><td style="background-color:#ffcc00; text-align:right; ">37</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ffcc00; ">B</td><td style="background-color:#ffcc00; text-align:right; ">94</td><td style="background-color:#ffcc00; text-align:right; ">12</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ffcc00; "> </td><td style="background-color:#ffcc00; "> </td><td style="background-color:#ffcc00; "> </td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ff0000; ">B</td><td style="background-color:#ff0000; text-align:right; ">15</td><td style="background-color:#ff0000; text-align:right; ">46</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ff0000; ">E</td><td style="background-color:#ff0000; text-align:right; ">80</td><td style="background-color:#ff0000; text-align:right; ">68</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ff0000; ">V</td><td style="background-color:#ff0000; text-align:right; ">86</td><td style="background-color:#ff0000; text-align:right; ">98</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#ff0000; ">M</td><td style="background-color:#ff0000; text-align:right; ">13</td><td style="background-color:#ff0000; text-align:right; ">44</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#ff0000; ">S</td><td style="background-color:#ff0000; text-align:right; ">12</td><td style="background-color:#ff0000; text-align:right; ">76</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >23</td><td style="background-color:#ff0000; "> </td><td style="background-color:#ff0000; "> </td><td style="background-color:#ff0000; "> </td></tr></table> <br />
Excel tables to the web - Excel Jeanie Html 4
Then a macro like this should help
Code:
Sub sbttls()
Dim aArea As Range
For Each aArea In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants).Areas
Cells(aArea.Row + aArea.Rows.Count, 2).Value = WorksheetFunction.Sum(Range(Cells(aArea.Row, 2), Cells(aArea.Row + aArea.Rows.Count - 1, 2)))
Cells(aArea.Row + aArea.Rows.Count, 3).Value = WorksheetFunction.Sum(Range(Cells(aArea.Row, 3), Cells(aArea.Row + aArea.Rows.Count - 1, 3)))
Next aArea
End Sub
Result
<b>Sheet1 (2)</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-style
utset;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-style
utset;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-style
utset;border-color:#f0f0f0; ">C</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; ">X</td><td style="background-color:#ffff00; text-align:right; ">53</td><td style="background-color:#ffff00; text-align:right; ">71</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffff00; ">N</td><td style="background-color:#ffff00; text-align:right; ">43</td><td style="background-color:#ffff00; text-align:right; ">1</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ffff00; ">X</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">15</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ffff00; ">N</td><td style="background-color:#ffff00; text-align:right; ">49</td><td style="background-color:#ffff00; text-align:right; ">93</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">146</td><td style="background-color:#ffff00; text-align:right; ">180</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ffcc00; ">L</td><td style="background-color:#ffcc00; text-align:right; ">12</td><td style="background-color:#ffcc00; text-align:right; ">68</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ffcc00; ">O</td><td style="background-color:#ffcc00; text-align:right; ">42</td><td style="background-color:#ffcc00; text-align:right; ">20</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ffcc00; ">O</td><td style="background-color:#ffcc00; text-align:right; ">12</td><td style="background-color:#ffcc00; text-align:right; ">85</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ffcc00; ">D</td><td style="background-color:#ffcc00; text-align:right; ">59</td><td style="background-color:#ffcc00; text-align:right; ">82</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ffcc00; ">W</td><td style="background-color:#ffcc00; text-align:right; ">55</td><td style="background-color:#ffcc00; text-align:right; ">33</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ffcc00; ">H</td><td style="background-color:#ffcc00; text-align:right; ">24</td><td style="background-color:#ffcc00; text-align:right; ">50</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ffcc00; ">J</td><td style="background-color:#ffcc00; text-align:right; ">76</td><td style="background-color:#ffcc00; text-align:right; ">72</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ffcc00; ">W</td><td style="background-color:#ffcc00; text-align:right; ">3</td><td style="background-color:#ffcc00; text-align:right; ">22</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ffcc00; ">D</td><td style="background-color:#ffcc00; text-align:right; ">87</td><td style="background-color:#ffcc00; text-align:right; ">5</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#ffcc00; ">I</td><td style="background-color:#ffcc00; text-align:right; ">8</td><td style="background-color:#ffcc00; text-align:right; ">37</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ffcc00; ">B</td><td style="background-color:#ffcc00; text-align:right; ">94</td><td style="background-color:#ffcc00; text-align:right; ">12</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ffcc00; "> </td><td style="background-color:#ffcc00; text-align:right; ">472</td><td style="background-color:#ffcc00; text-align:right; ">486</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ff0000; ">B</td><td style="background-color:#ff0000; text-align:right; ">15</td><td style="background-color:#ff0000; text-align:right; ">46</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ff0000; ">E</td><td style="background-color:#ff0000; text-align:right; ">80</td><td style="background-color:#ff0000; text-align:right; ">68</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ff0000; ">V</td><td style="background-color:#ff0000; text-align:right; ">86</td><td style="background-color:#ff0000; text-align:right; ">98</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#ff0000; ">M</td><td style="background-color:#ff0000; text-align:right; ">13</td><td style="background-color:#ff0000; text-align:right; ">44</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#ff0000; ">S</td><td style="background-color:#ff0000; text-align:right; ">12</td><td style="background-color:#ff0000; text-align:right; ">76</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style
utset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >23</td><td style="background-color:#ff0000; "> </td><td style="background-color:#ff0000; text-align:right; ">206</td><td style="background-color:#ff0000; text-align:right; ">332</td></tr></table> <br />
Excel tables to the web - Excel Jeanie Html 4