Sum function for different rows please

Venkateshwara Iyer · Apr 19, 2011

Dear Sir

Please help me to sum for different rows with an easy formula. cause the excel sheet has more than 15000 rows same every day

<html xmlns:o="urn:schemas-microsoft-com

ffice

ffice"

<INPUT class=SYN_LNN value=2 type=label unselectable="on"><INPUT id=syn_ctrl2 class=SYN_BCH role=button value=- type=label unselectable="on">
xmlns:x="urn:schemas-microsoft-com

ffice:excel"

<INPUT class=SYN_LNN value=3 type=label unselectable="on"><INPUT id=syn_ctrl3 class=SYN_BCH role=button value=- type=label unselectable="on">
xmlns="http://www.w3.org/TR/REC-html40">

<INPUT class=SYN_LNN value=4 type=label unselectable="on"><INPUT id=syn_ctrl4 class=SYN_BCH role=button value=- type=label unselectable="on">

<INPUT class=SYN_LNN value=5 type=label unselectable="on"><INPUT id=syn_ctrl5 class=SYN_BCH role=button value=- type=label unselectable="on">
<head>

<INPUT class=SYN_LNN value=6 type=label unselectable="on"><INPUT id=syn_ctrl6 class=SYN_BCH role=button value=- type=label unselectable="on">
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">

<INPUT class=SYN_LNN value=7 type=label unselectable="on"><INPUT id=syn_ctrl7 class=SYN_BCH role=button value=- type=label unselectable="on">
<meta name=ProgId content=Excel.Sheet>

<INPUT class=SYN_LNN value=8 type=label unselectable="on"><INPUT id=syn_ctrl8 class=SYN_BCH role=button value=- type=label unselectable="on">
<meta name=Generator content="Microsoft Excel 11">

<INPUT class=SYN_LNN value=9 type=label unselectable="on"><INPUT id=syn_ctrl9 class=SYN_BCH role=button value=- type=label unselectable="on">
<link rel=File-List href="NOW_files/filelist.xml">

<INPUT class=SYN_LNN value=10 type=label unselectable="on"><INPUT id=syn_ctrl10 class=SYN_BCH role=button value=- type=label unselectable="on">
<link rel=Edit-Time-Data href="NOW_files/editdata.mso">

<INPUT class=SYN_LNN value=11 type=label unselectable="on"><INPUT id=syn_ctrl11 class=SYN_BCH role=button value=- type=label unselectable="on">
<link rel=OLE-Object-Data href="NOW_files/oledata.mso">

<INPUT class=SYN_LNN value=12 type=label unselectable="on"><INPUT id=syn_ctrl12 class=SYN_BCH role=button value=- type=label unselectable="on">


<INPUT class=SYN_LNN value=94 type=label unselectable="on"><INPUT id=syn_ctrl94 class=SYN_BCH role=button value=- type=label unselectable="on">
<style>

<INPUT class=SYN_LNN value=95 type=label unselectable="on"><INPUT id=syn_ctrl95 class=SYN_BCH role=button value=- type=label unselectable="on">


<INPUT class=SYN_LNN value=155 type=label unselectable="on"><INPUT id=syn_ctrl155 class=SYN_BCH role=button value=- type=label unselectable="on">
</style>

<INPUT class=SYN_LNN value=156 type=label unselectable="on"><INPUT id=syn_ctrl156 class=SYN_BCH role=button value=- type=label unselectable="on">


<INPUT class=SYN_LNN value=199 type=label unselectable="on"><INPUT id=syn_ctrl199 class=SYN_BCH role=button value=- type=label unselectable="on">
</head>

<INPUT class=SYN_LNN value=200 type=label unselectable="on"><INPUT id=syn_ctrl200 class=SYN_BCH role=button value=- type=label unselectable="on">

<INPUT class=SYN_LNN value=201 type=label unselectable="on"><INPUT id=syn_ctrl201 class=SYN_BCH role=button value=- type=label unselectable="on">
<body link=blue vlink=purple>

<INPUT class=SYN_LNN value=202 type=label unselectable="on"><INPUT id=syn_ctrl202 class=SYN_BCH role=button value=- type=label unselectable="on">

<INPUT class=SYN_LNN value=203 type=label unselectable="on"><INPUT id=syn_ctrl203 class=SYN_BCH role=button value=- type=label unselectable="on">
<table x:str border=0 cellpadding=0 cellspacing=0 width=281 style='border-collapse:

<INPUT class=SYN_LNN value=204 type=label unselectable="on"><INPUT id=syn_ctrl204 class=SYN_BCH role=button value=- type=label unselectable="on">
collapse;table-layout:fixed;width:211pt'>

<INPUT class=SYN_LNN value=205 type=label unselectable="on"><INPUT id=syn_ctrl205 class=SYN_BCH role=button value=- type=label unselectable="on">
<col width=99 style='mso-width-source:userset;mso-width-alt:3620;width:74pt'>

<INPUT class=SYN_LNN value=206 type=label unselectable="on"><INPUT id=syn_ctrl206 class=SYN_BCH role=button value=- type=label unselectable="on">
<col width=60 style='mso-width-source:userset;mso-width-alt:2194;width:45pt'>

<INPUT class=SYN_LNN value=207 type=label unselectable="on"><INPUT id=syn_ctrl207 class=SYN_BCH role=button value=- type=label unselectable="on">
<col width=74 style='mso-width-source:userset;mso-width-alt:2706;width:56pt'>

<INPUT class=SYN_LNN value=208 type=label unselectable="on"><INPUT id=syn_ctrl208 class=SYN_BCH role=button value=- type=label unselectable="on">
<col width=48 style='width:36pt'>

<INPUT class=SYN_LNN value=209 type=label unselectable="on"><INPUT id=syn_ctrl209 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=210 type=label unselectable="on"><INPUT id=syn_ctrl210 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 width=99 style='height:12.75pt;width:74pt'>Item Code</td>

<INPUT class=SYN_LNN value=211 type=label unselectable="on"><INPUT id=syn_ctrl211 class=SYN_BCH role=button value=- type=label unselectable="on">
<td width=60 style='width:45pt'>Serve</td>

<INPUT class=SYN_LNN value=212 type=label unselectable="on"><INPUT id=syn_ctrl212 class=SYN_BCH role=button value=- type=label unselectable="on">
<td width=74 style='width:56pt'>Qty</td>

<INPUT class=SYN_LNN value=213 type=label unselectable="on"><INPUT id=syn_ctrl213 class=SYN_BCH role=button value=- type=label unselectable="on">
<td width=48 style='width:36pt'> </td>

<INPUT class=SYN_LNN value=214 type=label unselectable="on"><INPUT id=syn_ctrl214 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=215 type=label unselectable="on"><INPUT id=syn_ctrl215 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=216 type=label unselectable="on"><INPUT id=syn_ctrl216 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>HARISH</td>

<INPUT class=SYN_LNN value=217 type=label unselectable="on"><INPUT id=syn_ctrl217 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=218 type=label unselectable="on"><INPUT id=syn_ctrl218 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num><a name=Criteria>3</a></td>

<INPUT class=SYN_LNN value=219 type=label unselectable="on"><INPUT id=syn_ctrl219 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>300</td>

<INPUT class=SYN_LNN value=220 type=label unselectable="on"><INPUT id=syn_ctrl220 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=221 type=label unselectable="on"><INPUT id=syn_ctrl221 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=222 type=label unselectable="on"><INPUT id=syn_ctrl222 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>HARISH</td>

<INPUT class=SYN_LNN value=223 type=label unselectable="on"><INPUT id=syn_ctrl223 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=224 type=label unselectable="on"><INPUT id=syn_ctrl224 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=225 type=label unselectable="on"><INPUT id=syn_ctrl225 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>100</td>

<INPUT class=SYN_LNN value=226 type=label unselectable="on"><INPUT id=syn_ctrl226 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=227 type=label unselectable="on"><INPUT id=syn_ctrl227 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=228 type=label unselectable="on"><INPUT id=syn_ctrl228 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>HARISH</td>

<INPUT class=SYN_LNN value=229 type=label unselectable="on"><INPUT id=syn_ctrl229 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=230 type=label unselectable="on"><INPUT id=syn_ctrl230 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=231 type=label unselectable="on"><INPUT id=syn_ctrl231 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>50</td>

<INPUT class=SYN_LNN value=232 type=label unselectable="on"><INPUT id=syn_ctrl232 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=233 type=label unselectable="on"><INPUT id=syn_ctrl233 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=234 type=label unselectable="on"><INPUT id=syn_ctrl234 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>HARISH</td>

<INPUT class=SYN_LNN value=235 type=label unselectable="on"><INPUT id=syn_ctrl235 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=236 type=label unselectable="on"><INPUT id=syn_ctrl236 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>7</td>

<INPUT class=SYN_LNN value=237 type=label unselectable="on"><INPUT id=syn_ctrl237 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>30</td>

<INPUT class=SYN_LNN value=238 type=label unselectable="on"><INPUT id=syn_ctrl238 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=239 type=label unselectable="on"><INPUT id=syn_ctrl239 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=240 type=label unselectable="on"><INPUT id=syn_ctrl240 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>HARISH</td>

<INPUT class=SYN_LNN value=241 type=label unselectable="on"><INPUT id=syn_ctrl241 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=242 type=label unselectable="on"><INPUT id=syn_ctrl242 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>3</td>

<INPUT class=SYN_LNN value=243 type=label unselectable="on"><INPUT id=syn_ctrl243 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>30</td>

<INPUT class=SYN_LNN value=244 type=label unselectable="on"><INPUT id=syn_ctrl244 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=245 type=label unselectable="on"><INPUT id=syn_ctrl245 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=246 type=label unselectable="on"><INPUT id=syn_ctrl246 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>HARISH</td>

<INPUT class=SYN_LNN value=247 type=label unselectable="on"><INPUT id=syn_ctrl247 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=248 type=label unselectable="on"><INPUT id=syn_ctrl248 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=249 type=label unselectable="on"><INPUT id=syn_ctrl249 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>30</td>

<INPUT class=SYN_LNN value=250 type=label unselectable="on"><INPUT id=syn_ctrl250 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=251 type=label unselectable="on"><INPUT id=syn_ctrl251 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=252 type=label unselectable="on"><INPUT id=syn_ctrl252 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>TOTAL</td>

<INPUT class=SYN_LNN value=253 type=label unselectable="on"><INPUT id=syn_ctrl253 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=254 type=label unselectable="on"><INPUT id=syn_ctrl254 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38> </td>

<INPUT class=SYN_LNN value=255 type=label unselectable="on"><INPUT id=syn_ctrl255 class=SYN_BCH role=button value=- type=label unselectable="on">
<td> </td>

<INPUT class=SYN_LNN value=256 type=label unselectable="on"><INPUT id=syn_ctrl256 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=257 type=label unselectable="on"><INPUT id=syn_ctrl257 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=258 type=label unselectable="on"><INPUT id=syn_ctrl258 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>MANOJ</td>

<INPUT class=SYN_LNN value=259 type=label unselectable="on"><INPUT id=syn_ctrl259 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=260 type=label unselectable="on"><INPUT id=syn_ctrl260 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=261 type=label unselectable="on"><INPUT id=syn_ctrl261 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>25</td>

<INPUT class=SYN_LNN value=262 type=label unselectable="on"><INPUT id=syn_ctrl262 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=263 type=label unselectable="on"><INPUT id=syn_ctrl263 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=264 type=label unselectable="on"><INPUT id=syn_ctrl264 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>MANOJ</td>

<INPUT class=SYN_LNN value=265 type=label unselectable="on"><INPUT id=syn_ctrl265 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=266 type=label unselectable="on"><INPUT id=syn_ctrl266 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=267 type=label unselectable="on"><INPUT id=syn_ctrl267 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>15</td>

<INPUT class=SYN_LNN value=268 type=label unselectable="on"><INPUT id=syn_ctrl268 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=269 type=label unselectable="on"><INPUT id=syn_ctrl269 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=270 type=label unselectable="on"><INPUT id=syn_ctrl270 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>MANOJ</td>

<INPUT class=SYN_LNN value=271 type=label unselectable="on"><INPUT id=syn_ctrl271 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=272 type=label unselectable="on"><INPUT id=syn_ctrl272 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=273 type=label unselectable="on"><INPUT id=syn_ctrl273 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>40</td>

<INPUT class=SYN_LNN value=274 type=label unselectable="on"><INPUT id=syn_ctrl274 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=275 type=label unselectable="on"><INPUT id=syn_ctrl275 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=276 type=label unselectable="on"><INPUT id=syn_ctrl276 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>MANOJ</td>

<INPUT class=SYN_LNN value=277 type=label unselectable="on"><INPUT id=syn_ctrl277 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=278 type=label unselectable="on"><INPUT id=syn_ctrl278 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>2</td>

<INPUT class=SYN_LNN value=279 type=label unselectable="on"><INPUT id=syn_ctrl279 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>35</td>

<INPUT class=SYN_LNN value=280 type=label unselectable="on"><INPUT id=syn_ctrl280 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=281 type=label unselectable="on"><INPUT id=syn_ctrl281 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=282 type=label unselectable="on"><INPUT id=syn_ctrl282 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>TOTAL</td>

<INPUT class=SYN_LNN value=283 type=label unselectable="on"><INPUT id=syn_ctrl283 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=284 type=label unselectable="on"><INPUT id=syn_ctrl284 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38> </td>

<INPUT class=SYN_LNN value=285 type=label unselectable="on"><INPUT id=syn_ctrl285 class=SYN_BCH role=button value=- type=label unselectable="on">
<td> </td>

<INPUT class=SYN_LNN value=286 type=label unselectable="on"><INPUT id=syn_ctrl286 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=287 type=label unselectable="on"><INPUT id=syn_ctrl287 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=288 type=label unselectable="on"><INPUT id=syn_ctrl288 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=289 type=label unselectable="on"><INPUT id=syn_ctrl289 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=290 type=label unselectable="on"><INPUT id=syn_ctrl290 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=291 type=label unselectable="on"><INPUT id=syn_ctrl291 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>40</td>

<INPUT class=SYN_LNN value=292 type=label unselectable="on"><INPUT id=syn_ctrl292 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=293 type=label unselectable="on"><INPUT id=syn_ctrl293 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=294 type=label unselectable="on"><INPUT id=syn_ctrl294 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=295 type=label unselectable="on"><INPUT id=syn_ctrl295 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=296 type=label unselectable="on"><INPUT id=syn_ctrl296 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=297 type=label unselectable="on"><INPUT id=syn_ctrl297 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>54</td>

<INPUT class=SYN_LNN value=298 type=label unselectable="on"><INPUT id=syn_ctrl298 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=299 type=label unselectable="on"><INPUT id=syn_ctrl299 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=300 type=label unselectable="on"><INPUT id=syn_ctrl300 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=301 type=label unselectable="on"><INPUT id=syn_ctrl301 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=302 type=label unselectable="on"><INPUT id=syn_ctrl302 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=303 type=label unselectable="on"><INPUT id=syn_ctrl303 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>51</td>

<INPUT class=SYN_LNN value=304 type=label unselectable="on"><INPUT id=syn_ctrl304 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=305 type=label unselectable="on"><INPUT id=syn_ctrl305 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=306 type=label unselectable="on"><INPUT id=syn_ctrl306 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=307 type=label unselectable="on"><INPUT id=syn_ctrl307 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=308 type=label unselectable="on"><INPUT id=syn_ctrl308 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>4</td>

<INPUT class=SYN_LNN value=309 type=label unselectable="on"><INPUT id=syn_ctrl309 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>56</td>

<INPUT class=SYN_LNN value=310 type=label unselectable="on"><INPUT id=syn_ctrl310 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=311 type=label unselectable="on"><INPUT id=syn_ctrl311 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=312 type=label unselectable="on"><INPUT id=syn_ctrl312 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=313 type=label unselectable="on"><INPUT id=syn_ctrl313 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=314 type=label unselectable="on"><INPUT id=syn_ctrl314 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>6</td>

<INPUT class=SYN_LNN value=315 type=label unselectable="on"><INPUT id=syn_ctrl315 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>84</td>

<INPUT class=SYN_LNN value=316 type=label unselectable="on"><INPUT id=syn_ctrl316 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=317 type=label unselectable="on"><INPUT id=syn_ctrl317 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=318 type=label unselectable="on"><INPUT id=syn_ctrl318 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=319 type=label unselectable="on"><INPUT id=syn_ctrl319 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=320 type=label unselectable="on"><INPUT id=syn_ctrl320 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=321 type=label unselectable="on"><INPUT id=syn_ctrl321 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>20</td>

<INPUT class=SYN_LNN value=322 type=label unselectable="on"><INPUT id=syn_ctrl322 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=323 type=label unselectable="on"><INPUT id=syn_ctrl323 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=324 type=label unselectable="on"><INPUT id=syn_ctrl324 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=325 type=label unselectable="on"><INPUT id=syn_ctrl325 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=326 type=label unselectable="on"><INPUT id=syn_ctrl326 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=327 type=label unselectable="on"><INPUT id=syn_ctrl327 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>22</td>

<INPUT class=SYN_LNN value=328 type=label unselectable="on"><INPUT id=syn_ctrl328 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=329 type=label unselectable="on"><INPUT id=syn_ctrl329 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=330 type=label unselectable="on"><INPUT id=syn_ctrl330 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=331 type=label unselectable="on"><INPUT id=syn_ctrl331 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=332 type=label unselectable="on"><INPUT id=syn_ctrl332 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>2</td>

<INPUT class=SYN_LNN value=333 type=label unselectable="on"><INPUT id=syn_ctrl333 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>45</td>

<INPUT class=SYN_LNN value=334 type=label unselectable="on"><INPUT id=syn_ctrl334 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=335 type=label unselectable="on"><INPUT id=syn_ctrl335 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=336 type=label unselectable="on"><INPUT id=syn_ctrl336 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=337 type=label unselectable="on"><INPUT id=syn_ctrl337 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=338 type=label unselectable="on"><INPUT id=syn_ctrl338 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=339 type=label unselectable="on"><INPUT id=syn_ctrl339 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>10</td>

<INPUT class=SYN_LNN value=340 type=label unselectable="on"><INPUT id=syn_ctrl340 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=341 type=label unselectable="on"><INPUT id=syn_ctrl341 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=342 type=label unselectable="on"><INPUT id=syn_ctrl342 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>JAGADISH</td>

<INPUT class=SYN_LNN value=343 type=label unselectable="on"><INPUT id=syn_ctrl343 class=SYN_BCH role=button value=- type=label unselectable="on">
<td>PLASTIC</td>

<INPUT class=SYN_LNN value=344 type=label unselectable="on"><INPUT id=syn_ctrl344 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38 align=right x:num>1</td>

<INPUT class=SYN_LNN value=345 type=label unselectable="on"><INPUT id=syn_ctrl345 class=SYN_BCH role=button value=- type=label unselectable="on">
<td align=right x:num>15</td>

<INPUT class=SYN_LNN value=346 type=label unselectable="on"><INPUT id=syn_ctrl346 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=347 type=label unselectable="on"><INPUT id=syn_ctrl347 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=17 style='height:12.75pt'>

<INPUT class=SYN_LNN value=348 type=label unselectable="on"><INPUT id=syn_ctrl348 class=SYN_BCH role=button value=- type=label unselectable="on">
<td height=17 style='height:12.75pt'>TOTAL</td>

<INPUT class=SYN_LNN value=349 type=label unselectable="on"><INPUT id=syn_ctrl349 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38> </td>

<INPUT class=SYN_LNN value=350 type=label unselectable="on"><INPUT id=syn_ctrl350 class=SYN_BCH role=button value=- type=label unselectable="on">
<td class=xl38> </td>

<INPUT class=SYN_LNN value=351 type=label unselectable="on"><INPUT id=syn_ctrl351 class=SYN_BCH role=button value=- type=label unselectable="on">
<td> </td>

<INPUT class=SYN_LNN value=352 type=label unselectable="on"><INPUT id=syn_ctrl352 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=353 type=label unselectable="on"><INPUT id=syn_ctrl353 class=SYN_BCH role=button value=- type=label unselectable="on">
<![if supportMisalignedColumns]>

<INPUT class=SYN_LNN value=354 type=label unselectable="on"><INPUT id=syn_ctrl354 class=SYN_BCH role=button value=- type=label unselectable="on">
<tr height=0 style='display:none'>

<INPUT class=SYN_LNN value=355 type=label unselectable="on"><INPUT id=syn_ctrl355 class=SYN_BCH role=button value=- type=label unselectable="on">
<td width=99 style='width:74pt'></td>

<INPUT class=SYN_LNN value=356 type=label unselectable="on"><INPUT id=syn_ctrl356 class=SYN_BCH role=button value=- type=label unselectable="on">
<td width=60 style='width:45pt'></td>

<INPUT class=SYN_LNN value=357 type=label unselectable="on"><INPUT id=syn_ctrl357 class=SYN_BCH role=button value=- type=label unselectable="on">
<td width=74 style='width:56pt'></td>

<INPUT class=SYN_LNN value=358 type=label unselectable="on"><INPUT id=syn_ctrl358 class=SYN_BCH role=button value=- type=label unselectable="on">
<td width=48 style='width:36pt'></td>

<INPUT class=SYN_LNN value=359 type=label unselectable="on"><INPUT id=syn_ctrl359 class=SYN_BCH role=button value=- type=label unselectable="on">
</tr>

<INPUT class=SYN_LNN value=360 type=label unselectable="on"><INPUT id=syn_ctrl360 class=SYN_BCH role=button value=- type=label unselectable="on">
<![endif]>

<INPUT class=SYN_LNN value=361 type=label unselectable="on"><INPUT id=syn_ctrl361 class=SYN_BCH role=button value=- type=label unselectable="on">
</table>

<INPUT class=SYN_LNN value=362 type=label unselectable="on"><INPUT id=syn_ctrl362 class=SYN_BCH role=button value=- type=label unselectable="on">

<INPUT class=SYN_LNN value=363 type=label unselectable="on"><INPUT id=syn_ctrl363 class=SYN_BCH role=button value=- type=label unselectable="on">
</body>

<INPUT class=SYN_LNN value=364 type=label unselectable="on"><INPUT id=syn_ctrl364 class=SYN_BCH role=button value=- type=label unselectable="on">

<INPUT class=SYN_LNN value=365 type=label unselectable="on"><INPUT id=syn_ctrl365 class=SYN_BCH role=button value=- type=label unselectable="on">
</html>

<INPUT class=SYN_LNN value=366 type=label unselectable="on"><INPUT id=syn_ctrl366 class=SYN_BCH role=button value=- type=label unselectable="on">

JamesW · Apr 19, 2011

Hi,

Not sure which rows you want to sum as the HTML code you posted is slightly confusing..

Venkateshwara Iyer · Apr 19, 2011

am sorry for the trouble

<TABLE style="WIDTH: 211pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=281 x:str><COLGROUP><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3620" width=99><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 36pt" width=48><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 74pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=99>Item Code</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 45pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=60>Serve</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=74>Qty</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 36pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=48>value</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>HARISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>3</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>300</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>HARISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>100</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>HARISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>50</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>HARISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>7</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>30</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>HARISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>3</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>30</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>HARISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>30</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>TOTAL</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>MANOJ</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>25</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>MANOJ</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>15</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>MANOJ</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>40</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>MANOJ</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>2</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>35</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>TOTAL</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>40</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>54</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>51</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>4</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>56</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>6</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>84</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>20</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>22</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>2</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>45</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>JAGADISH</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">PLASTIC</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36 align=right x:num>1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>15</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>TOTAL</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl36> </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"> </TD></TR></TBODY></TABLE>

qty to be totalled each time easy way to do that. cause it will have 15000 to 50000 cells every day

Sum function for different rows please

Venkateshwara Iyer

New Member

Excel Facts

JamesW

Well-known Member

Venkateshwara Iyer

New Member

Similar threads

Forum statistics

Share this page

Sum function for different rows please

Venkateshwara Iyer

New Member

Excel Facts

JamesW

Well-known Member

Venkateshwara Iyer

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock