Error in formula

S

sankar_PHI

New Member
Joined
Aug 16, 2009
Messages
22
<TABLE style="WIDTH: 816pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1089 border=0><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl73 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 233pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=310 colSpan=2 height=18>Season ( C column )</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 164pt; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8" width=219>Rainy Sesaon 2009</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 143pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=191>( I have put manully this figure )</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 164pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=219>Request Automatic formula</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 56pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=75></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 56pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=75></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=2 height=18>Warehouse Description ( D column )</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">( I have put manully this figure )</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">Request Automatic formula</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=2 height=18>Crop ( E column )</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">Rice</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">( I have put manully this figure )</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">Request Automatic formula</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=2 height=18>Product Description ( F column )</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">PHB71-2K-15 PACKETS PER BAG</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">( I have put manully this figure )</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">Request Automatic formula</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=2 height=18>Return Date ( G column )</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">25-Jun-09</TD><TD class=xl95 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; mso-ignore: colspan" colSpan=3>( I have created formula which is the correct one whereas if I select G and H entire column, data is providing wrong</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl68 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" colSpan=2 height=21>Return in Kgs (H column )</TD><TD class=xl94 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">2366</TD><TD class=xl72 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; mso-ignore: colspan" colSpan=2>I think the formula I have created is OK for me</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=17></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=17></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=17></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=17></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=17></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=17></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=18></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=18>Sum of UOM Kgs</TD><TD class=xl69 style="BORDER-TOP: windowtext 1pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl69 style="BORDER-TOP: windowtext 1pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl69 style="BORDER-TOP: windowtext 1pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl69 style="BORDER-TOP: windowtext 1pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl69 style="BORDER-TOP: windowtext 1pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl67 style="BORDER-LEFT: windowtext 1pt solid; WIDTH: 113pt; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=150 height=69>Sales Return Chalan No</TD><TD class=xl70 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 120pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=160>Season Name</TD><TD class=xl70 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 164pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=219>Warehouse Description</TD><TD class=xl76 style="BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 143pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=191>Crop</TD><TD class=xl70 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 164pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=219>Product Description</TD><TD class=xl71 style="BORDER-LEFT: black 0.5pt solid; WIDTH: 56pt; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=75>Sales Return Chalan Date</TD><TD class=xl77 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 56pt; BACKGROUND-COLOR: transparent" width=75>Total</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl78 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00110/10</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">Rainy Sesaon 2009</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">Rice</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">PHB71-2K-15 PACKETS PER BAG</TD><TD class=xl80 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">22-Jun-09</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090">944</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl78 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00111/10</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">Rainy Sesaon 2009</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">Rice</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">PHB71-2K-15 PACKETS PER BAG</TD><TD class=xl80 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">27-Jun-09</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090">162</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl78 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00112/10</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">Rainy Sesaon 2009</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">Rice</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">PHB71-2K-15 PACKETS PER BAG</TD><TD class=xl80 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">27-Jun-09</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090">960</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl78 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00113/10</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">Rainy Sesaon 2009</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">Rice</TD><TD class=xl79 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">PHB71-2K-15 PACKETS PER BAG</TD><TD class=xl80 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090; BORDER-RIGHT-COLOR: #ece9d8">27-Jun-09</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #fac090">300</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl86 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00114/10</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">Rainy Sesaon 2009</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">Rice</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">PHB71-3K-15 PACKETS PER BAG</TD><TD class=xl88 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">27-Jun-09</TD><TD class=xl89 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8">150</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl86 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00115/10</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">Rainy Sesaon 2009</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">Rice</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">PHB71-3K-15 PACKETS PER BAG</TD><TD class=xl88 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">27-Jun-09</TD><TD class=xl89 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8">460</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl86 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00116/10</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">Rainy Sesaon 2009</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">Rice</TD><TD class=xl87 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">PHB71-3K-15 PACKETS PER BAG</TD><TD class=xl88 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8; BORDER-RIGHT-COLOR: #ece9d8">27-Jun-09</TD><TD class=xl89 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #b6dde8">1342</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl82 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00015/10</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">Summer Season 2009</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">Corn</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">31Y45-16K KERNEL</TD><TD class=xl84 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">22-Apr-09</TD><TD class=xl85 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc">552</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl82 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00016/10</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">Summer Season 2009</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">Corn</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">31Y45-16K KERNEL</TD><TD class=xl84 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">22-Apr-09</TD><TD class=xl85 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc">312</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl82 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8" height=17>AG/SRR/00017/10</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">Summer Season 2009</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">Corn</TD><TD class=xl83 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">31Y45-16K KERNEL</TD><TD class=xl84 style="BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">22-Apr-09</TD><TD class=xl85 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d7e4bc">268.8</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl90 style="BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8" height=18>AG/SRR/00124/10</TD><TD class=xl91 style="BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">Summer Season 2009</TD><TD class=xl91 style="BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">AGRA</TD><TD class=xl91 style="BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">Corn</TD><TD class=xl91 style="BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">31Y45-16K KERNEL</TD><TD class=xl92 style="BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc; BORDER-RIGHT-COLOR: #ece9d8">2-Jul-09</TD><TD class=xl93 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc">432</TD></TR></TBODY></TABLE>

Can someone help me please. My questions are above mentioned and i tried but no luck, Thanks in advance to help me<!-- / message --><!-- sig -->
 
Sort by date Sort by votes
andrew, finally I won by using this formula

=SUMPRODUCT(--(B15:B25=C1),--(C15:C25=C2),--(D15:D25=C3),--(E15:E25=C4),F15:F25,G15:G25/SUMPRODUCT(--(B15:B25=C1),--(C15:C25=C2),--(D15:D25=C3),--(E15:E25=C4),G15:G25))

But you made me to win, win, win, Thanks for your indefatigable efforts, thanks onceagain
 
Upvote 0

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
You must log in or register to reply here.

Similar threads

V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
315
VBAEXCELNew
V
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
821
gvsumich
G
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
348
esben
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,214,832
Messages
6,121,841
Members
449,051
Latest member
excelquestion515

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top