Change Part of a formula in a Range by Check Box

Status
Not open for further replies.
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
 
Last edited:

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
Hi Sadi

Per the forum rules duplicate threads will be locked or deleted. Please pursue your original thread.

Thanks.
 
Upvote 0
Status
Not open for further replies.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
617
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
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
920
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C

Forum statistics

Threads
1,224,521
Messages
6,179,291
Members
452,902
Latest member
Knuddeluff

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