I need an equation to sum multiple columns based on multiple rows.
any ideas?
example
<table width="388" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 51pt;" width="68"> <col style="width: 48pt;" width="64" span="4"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" width="64" height="17">
</td> <td style="width: 51pt;" width="68" align="right">
</td> <td style="width: 48pt;" width="64" align="right">
</td> <td style="width: 48pt;" width="64" align="right">
</td> <td style="width: 48pt;" width="64" align="right">
</td> <td style="width: 48pt;" width="64" align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">
</td> <td class="xl67">Pix</td> <td class="xl67">Entry</td> <td class="xl67">Banquet</td> <td class="xl67">Banquet</td> <td class="xl67">Entry</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922070</td> <td class="xl69"> 10</td> <td class="xl69"> 100</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922073</td> <td class="xl69">
</td> <td class="xl69"> 125</td> <td class="xl69"> 50</td> <td class="xl69">
</td> <td class="xl69">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922075</td> <td class="xl69"> 5
</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69"> 50</td> <td class="xl69">100
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922073</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69"> 50</td> <td class="xl69">
</td> <td class="xl69"> 125</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922070</td> <td class="xl69"> 1</td> <td class="xl69">
</td> <td class="xl69"> 50</td> <td class="xl69">
</td> <td class="xl69"> 125</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922070</td> <td class="xl69">
</td> <td class="xl69"> 100</td> <td class="xl69">
</td> <td class="xl69"> 50</td> <td class="xl69">
</td> </tr> </tbody></table>
so I need to end up with
922070 pix total of 11
922070 entry total of 325
etc
thank you!
any ideas?
example
<table width="388" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 51pt;" width="68"> <col style="width: 48pt;" width="64" span="4"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" width="64" height="17">
</td> <td style="width: 51pt;" width="68" align="right">
</td> <td style="width: 48pt;" width="64" align="right">
</td> <td style="width: 48pt;" width="64" align="right">
</td> <td style="width: 48pt;" width="64" align="right">
</td> <td style="width: 48pt;" width="64" align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">
</td> <td class="xl67">Pix</td> <td class="xl67">Entry</td> <td class="xl67">Banquet</td> <td class="xl67">Banquet</td> <td class="xl67">Entry</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922070</td> <td class="xl69"> 10</td> <td class="xl69"> 100</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922073</td> <td class="xl69">
</td> <td class="xl69"> 125</td> <td class="xl69"> 50</td> <td class="xl69">
</td> <td class="xl69">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922075</td> <td class="xl69"> 5
</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69"> 50</td> <td class="xl69">100
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922073</td> <td class="xl69">
</td> <td class="xl69">
</td> <td class="xl69"> 50</td> <td class="xl69">
</td> <td class="xl69"> 125</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922070</td> <td class="xl69"> 1</td> <td class="xl69">
</td> <td class="xl69"> 50</td> <td class="xl69">
</td> <td class="xl69"> 125</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl64" style="height: 13.5pt;" align="right" height="18">922070</td> <td class="xl69">
</td> <td class="xl69"> 100</td> <td class="xl69">
</td> <td class="xl69"> 50</td> <td class="xl69">
</td> </tr> </tbody></table>
so I need to end up with
922070 pix total of 11
922070 entry total of 325
etc
thank you!