Change Part of a formula in a Range

sadi

sadi

Board Regular
Joined
Jun 27, 2009
Messages
93
Dear all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>
I want to change the marked part of formula with (two group) two check boxes.
If I check “check box 1” than P2 (group 1) (in formula) will change to E2 or F2...
& if check box 2 (group 2) will check Sheet name in formula will change to sheet 2 or sheet 3
Your can see detail in below table...

<TABLE class=MsoNormalTable style="MARGIN: auto auto auto 5.15pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0in 5.4pt 0in 5.4pt" cellSpacing=0 cellPadding=0 border=0><TBODY><TR style="HEIGHT: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-alt: solid silver .5pt" vAlign=top><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom noWrap>A<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>B<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>C<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>D<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>E<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>F<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>G<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>H<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>I<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>J<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>K<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 1"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt" vAlign=top>1<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt" vAlign=bottom noWrap>Territory<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>January<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>February<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>Total<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>SUP<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>Route<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>SE Name<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>Value Class<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>Thana<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>POS Category<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>POS Type<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 2"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=top>2<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
=SUMIF('Sheet1'!$P$3:$P$30000,P2,' Sheet1'!C$3:C$30000)<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
=SUMIF(' Sheet1'!$P$3:$P$30000,P2,' Sheet1'!D$3:D$30000)<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 3"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=top>3<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
=SUMIF(' Sheet1'!$P$3:$P$30000,P3,' Sheet1'!C$3:C$30000)<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
=SUMIF(' Sheet1'!$P$3:$P$30000,P3,' Sheet1'!D$3:D$30000)<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 4"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=top>4<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 5; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=top>5<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD></TR></TBODY></TABLE>

Please help me.....

SADI
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Sort by date Sort by votes
Sorry sadi I do not understand what you want say ? what is P2 and where are groups ? Kindly make us understand to resolve the same.
 
Upvote 0
Assuming there should only be one checked in each group, use option buttons instead.

Use a formula on the principle of

=SUMIF(Sheet1!$P$3:$P$30000,CHOOSE(control1,P2,P3,P4,etc),CHOOSE(control2,Sheet1!C$3:C$30000,Sheet1!D$3:D$30000,Sheet1!E$3:E$30000))

Note that control1 and control2 refer to the control cells for group 1 and group 2 respectively.
 
Upvote 0
Dear all,
Sorry for my innocence...
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>
I want to change the marked part of formula with (two group, Check Box group 1 Change the cell reference & Other Group Change the Sheet Name) two check boxes.
If I check “check box 1” than P2 (Cell Reference in formula) (From group 1) will change to E2 or F2... instead of P2
<o:p> </o:p>
& if check box 2 (group 2) will check Sheet name in formula will change to sheet 2 or sheet 3.... Instead of Sheet 1
Your can see detail in below table...
<TABLE class=MsoNormalTable style="MARGIN: auto auto auto 5.15pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0in 5.4pt 0in 5.4pt" cellSpacing=0 cellPadding=0 border=0><TBODY><TR style="HEIGHT: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-alt: solid silver .5pt" vAlign=top><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom noWrap>A<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>B<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>C<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>D<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>E<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>F<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>G<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>H<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>I<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>J<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: silver 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>K<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 1"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt" vAlign=top>1<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt" vAlign=bottom noWrap>Territory<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>January<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>February<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>Total<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>SUP<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>Route<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>SE Name<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>Value Class<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>Thana<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>POS Category<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>POS Type<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 2"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=top>2<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
=SUMIF('Sheet1'!$P$3:$P$30000,P2,' Sheet1'!C$3:C$30000)<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
=SUMIF(' Sheet1'!$P$3:$P$30000,P2,' Sheet1'!D$3:D$30000)<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 3"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=top>3<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
=SUMIF(' Sheet1'!$P$3:$P$30000,P3,' Sheet1'!C$3:C$30000)<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
=SUMIF(' Sheet1'!$P$3:$P$30000,P3,' Sheet1'!D$3:D$30000)<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 4"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=top>4<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 5; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: silver 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=top>5<o:p></o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-left-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap>
<o:p> </o:p>​
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD><TD style="BORDER-RIGHT: silver 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: silver 1pt solid; HEIGHT: 15pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom noWrap><o:p> </o:p>
</TD></TR></TBODY></TABLE>

I think now you can understand
sadi
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
501
VBAEXCELNew
V
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
921
epactheactor
E

Forum statistics

Threads
1,224,603
Messages
6,179,849
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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