Question

[sach.gaikwad]

<TABLE style="WIDTH: 171pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=228><COLGROUP><COL style="WIDTH: 171pt; mso-width-source: userset; mso-width-alt: 8338" width=228><TBODY><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; WIDTH: 171pt; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0 0.5pt; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30 width=228>C27,25,39</TD></TR></TBODY></TABLE>
How to calculate No. of commas in the above cell

 

[Jon von der Heyden]

Hi and welcome to the board!

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

 

[sach.gaikwad]

Thanks a lot

 

[sach.gaikwad]

<TABLE style="WIDTH: 331pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=441><COLGROUP><COL style="WIDTH: 258pt; mso-width-source: userset; mso-width-alt: 12580" width=344><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><TBODY><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; WIDTH: 258pt; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl360 height=30 width=344>C1,6,33,67</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; WIDTH: 73pt; BORDER-TOP: #f0f0f0 0.5pt; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356 width=97>4</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl360 height=30> </TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>4</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30>C3,4,8,13,22,27,31,34,39,40,51,52,56,61,65,76</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>16</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30> </TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>16</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30>C7,9,10,12,15,23,26,28,29,32,36</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>11</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30> </TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>11</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30>C16,17,18,19,21,30,49,50</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>8</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30> </TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>8</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C20,54,60,62</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>4</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C24,44</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>2</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C25,35,48</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>3</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C43</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>1</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30>C74,78</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>2</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30> </TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>2</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C71</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>1</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C47,57,58</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>3</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C53</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>1</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C64,68,70</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>3</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C69,73</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>2</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C72</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>1</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C75,77</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>2</TD></TR></TBODY></TABLE> How can i make sum of the numbers infront of the text only??

 

[sach.gaikwad]

<TABLE style="WIDTH: 331pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=441><COLGROUP><COL style="WIDTH: 258pt; mso-width-source: userset; mso-width-alt: 12580" width=344><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><TBODY><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; WIDTH: 258pt; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl360 height=30 width=344>C1,6,33,67</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; WIDTH: 73pt; BORDER-TOP: #f0f0f0 0.5pt; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356 width=97>4</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl360 height=30></TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>4</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30>C3,4,8,13,22,27,31,34,39,40,51,52,56,61,65,76</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>16</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30></TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>16</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30>C7,9,10,12,15,23,26,28,29,32,36</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>11</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30></TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>11</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30>C16,17,18,19,21,30,49,50</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>8</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30></TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>8</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C20,54,60,62</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>4</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C24,44</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>2</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C25,35,48</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>3</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C43</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>1</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30>C74,78</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>2</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #ffffcc; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl359 height=30></TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl356>2</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: transparent; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl353 height=30>C71</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl352>1</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C47,57,58</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>3</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C53</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>1</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C64,68,70</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>3</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C69,73</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>2</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C72</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>1</TD></TR><TR style="HEIGHT: 22.5pt; mso-height-source: userset; mso-outline-level: 1" height=30><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0 0.5pt; BACKGROUND-COLOR: #fde9d9; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl358 height=30>C75,77</TD><TD style="BORDER-BOTTOM: #f0f0f0 0.5pt; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0 0.5pt" class=xl357>2</TD></TR></TBODY></TABLE>How can i make sum of the numbers infront of the text only??

 

[Jon von der Heyden]

I'm not sure I understand your question. Do you mean SUM the numbers where they have a corresponding entry in the (left) adjacent column?

=SUMIF(A:A,"<>"&"",B:B)

 

[sach.gaikwad]

Thanks alot your asssumption is right...

 

[sach.gaikwad]

how to write 2'-6" in excell i.e feet & inch format