Error in formula

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 -->
 

sankar_PHI

New Member
Joined
Aug 16, 2009
Messages
22
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
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Watch MrExcel Video

Forum statistics

Threads
1,108,933
Messages
5,525,693
Members
409,660
Latest member
1817538628

This Week's Hot Topics

Top