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

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Better post the formula that returns an error.

I don't see how you can have formulas for the first 4 items. Aren't they your criteria?
 

sankar_PHI

New Member
Joined
Aug 16, 2009
Messages
22
Thanks Andrew to attend, Infact, first 4 are criteria only.

I could not get Return Date Formula whereas answer is 25th June 2009. I should get answer 25th June 2009 by having 4 criterias by selecting G and H Column

Could you guide me
 
Last edited:

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
How can it be 25 June 2009? The only 2 dates for those criteria are 22 and 27 June 2009.

Can you give range references for the data you posted please?
 

sankar_PHI

New Member
Joined
Aug 16, 2009
Messages
22

ADVERTISEMENT

<TABLE style="WIDTH: 816pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1089 border=0><COLGROUP><COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 5485" width=150><COL style="WIDTH: 120pt; mso-width-source: userset; mso-width-alt: 5851" width=160><COL style="WIDTH: 164pt; mso-width-source: userset; mso-width-alt: 8009" width=219><COL style="WIDTH: 143pt; mso-width-source: userset; mso-width-alt: 6985" width=191><COL style="WIDTH: 164pt; mso-width-source: userset; mso-width-alt: 8009" width=219><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" span=2 width=75><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl95 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=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 164pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090" width=219>Rainy Sesaon 2009</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 143pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=191>Criteria</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 164pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=219></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl70 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=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">AGRA</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Criteria</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl70 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=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">Rice</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Criteria</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl70 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=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">PHB71-2K-15 PACKETS PER BAG</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Criteria</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl70 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=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">25-Jun-09</TD><TD class=xl94 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; 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-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl70 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=xl93 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">2366</TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan" colSpan=2>I think the formula I have created is OK for me</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>Sum of UOM Kgs</TD><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 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=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; WIDTH: 113pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent" width=150 height=69>Sales Return Chalan No</TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 120pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=160>Season Name</TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 164pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=219>Warehouse Description</TD><TD class=xl75 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 143pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=191>Crop</TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 164pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=219>Product Description</TD><TD class=xl73 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: black 0.5pt solid; WIDTH: 56pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=75>Sales Return Chalan Date</TD><TD class=xl76 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>Total</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #fac090" height=17>AG/SRR/00110/10</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">Rainy Sesaon 2009</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">AGRA</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">Rice</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">PHB71-2K-15 PACKETS PER BAG</TD><TD class=xl79 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">22-Jun-09</TD><TD class=xl80 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">944</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #fac090" height=17>AG/SRR/00111/10</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">Rainy Sesaon 2009</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">AGRA</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">Rice</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">PHB71-2K-15 PACKETS PER BAG</TD><TD class=xl79 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">27-Jun-09</TD><TD class=xl80 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">162</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #fac090" height=17>AG/SRR/00112/10</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">Rainy Sesaon 2009</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">AGRA</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">Rice</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">PHB71-2K-15 PACKETS PER BAG</TD><TD class=xl79 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">27-Jun-09</TD><TD class=xl80 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">960</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #fac090" height=17>AG/SRR/00113/10</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">Rainy Sesaon 2009</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">AGRA</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">Rice</TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">PHB71-2K-15 PACKETS PER BAG</TD><TD class=xl79 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">27-Jun-09</TD><TD class=xl80 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #fac090">300</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #b6dde8" height=17>AG/SRR/00114/10</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">Rainy Sesaon 2009</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">AGRA</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">Rice</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">PHB71-3K-15 PACKETS PER BAG</TD><TD class=xl87 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">27-Jun-09</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">150</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #b6dde8" height=17>AG/SRR/00115/10</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">Rainy Sesaon 2009</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">AGRA</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">Rice</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">PHB71-3K-15 PACKETS PER BAG</TD><TD class=xl87 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">27-Jun-09</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">460</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #b6dde8" height=17>AG/SRR/00116/10</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">Rainy Sesaon 2009</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">AGRA</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">Rice</TD><TD class=xl86 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">PHB71-3K-15 PACKETS PER BAG</TD><TD class=xl87 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">27-Jun-09</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #b6dde8">1342</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #d7e4bc" height=17>AG/SRR/00015/10</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">Summer Season 2009</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">AGRA</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">Corn</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">31Y45-16K KERNEL</TD><TD class=xl83 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">22-Apr-09</TD><TD class=xl84 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">552</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #d7e4bc" height=17>AG/SRR/00016/10</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">Summer Season 2009</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">AGRA</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">Corn</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">31Y45-16K KERNEL</TD><TD class=xl83 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">22-Apr-09</TD><TD class=xl84 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">312</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #d7e4bc" height=17>AG/SRR/00017/10</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">Summer Season 2009</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">AGRA</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">Corn</TD><TD class=xl82 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">31Y45-16K KERNEL</TD><TD class=xl83 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">22-Apr-09</TD><TD class=xl84 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d7e4bc">268.8</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl89 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #d7e4bc" height=18>AG/SRR/00124/10</TD><TD class=xl90 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc">Summer Season 2009</TD><TD class=xl90 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc">AGRA</TD><TD class=xl90 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc">Corn</TD><TD class=xl90 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc">31Y45-16K KERNEL</TD><TD class=xl91 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #d7e4bc">2-Jul-09</TD><TD class=xl92 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>

attached onceagain, is it advised by you,
 

sankar_PHI

New Member
Joined
Aug 16, 2009
Messages
22

ADVERTISEMENT

How can it be 25 June 2009? The only 2 dates for those criteria are 22 and 27 June 2009.

Can you give range references for the data you posted please?

Yes, The answer should be 25th June 2009 if I wanted to use 4 criteria. The range i used to arrive 25th June 2009 is =SUMPRODUCT(G17:G20,H17:H20/SUM(H17:H20)) whereas I can't put this formula because I have data more than 30000 rows in G and H columns.

Did I attempt to seek your clarification,

Thanks to attend as I expected,
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
That's the average date, like this:

=SUMPRODUCT(--(B17:B27=C1),--(C17:C27=C2),--(D17:D27=C3),--(E17:E27=C4),F17:F27)/SUMPRODUCT(--(B17:B27=C1),--(C17:C27=C2),--(D17:D27=C3),--(E17:E27=C4))
 

sankar_PHI

New Member
Joined
Aug 16, 2009
Messages
22
Andrew, Thanks to clarify, but my answer should be by using sumproduct of G column and H column / sum of h column. I have used this formula SUMPRODUCT(G17:G20,H17:H20/SUM(H17:H20)) whereas you have given me help NOT using H column.

I feel, am i not explaining properly, Kindly excuse me and educate.....if you could change/alter any of different criteria by using your formula, my answer is giving more variation.

could you please
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Do you mean?

=SUMPRODUCT(--(C17:C27=C1),--(D17:D27=C2),--(E17:E27=C3),--(F17:F27=C4),G17:G27)/SUMPRODUCT(--(C17:C27=C1),--(D17:D27=C2),--(E17:E27=C3),--(F17:F27=C4))

I assumed your table was in the range A15:G27. The above formula assumes it's in B15:H27. That's why I asked you for range references.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,450
Messages
5,523,065
Members
409,495
Latest member
bkahn

This Week's Hot Topics

Top