https://community.jmp.com/t5/Discussions/JSL-count-quot-F-quot-and-quot-M-quot-characters-in-a-column/m-p/395902#M64661 <P>Hello,<BR />I have this table 1 below and I want to summaries it by number of&nbsp;<SPAN>instances&nbsp;of "F" and "M" (Table 2).</SPAN></P><P><SPAN>How do I do that?</SPAN></P><P><SPAN>Thanks in advance.</SPAN></P><P><SPAN>Table 1:</SPAN></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><STRONG>Name</STRONG></TD><TD><STRONG>F</STRONG></TD><TD><STRONG>M</STRONG></TD></TR><TR><TD>KATIE</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>LOUISE</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>JANE</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>JACLYN</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>LILLIE</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>TIM</TD><TD>&nbsp;</TD><TD>M</TD></TR><TR><TD>JAMES</TD><TD>&nbsp;</TD><TD>M</TD></TR><TR><TD>ROBERT</TD><TD>&nbsp;</TD><TD>M</TD></TR></TBODY></TABLE><P><SPAN>Table 2:</SPAN></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><STRONG>Count_F</STRONG></TD><TD><STRONG>Count_M</STRONG></TD></TR><TR><TD>5</TD><TD>3</TD></TR></TBODY></TABLE> Sat, 10 Jun 2023 23:32:27 GMT ileshem 2023-06-10T23:32:27Z https://community.jmp.com/t5/Discussions/JSL-count-quot-F-quot-and-quot-M-quot-characters-in-a-column/m-p/395902#M64661 <P>Hello,<BR />I have this table 1 below and I want to summaries it by number of&nbsp;<SPAN>instances&nbsp;of "F" and "M" (Table 2).</SPAN></P><P><SPAN>How do I do that?</SPAN></P><P><SPAN>Thanks in advance.</SPAN></P><P><SPAN>Table 1:</SPAN></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><STRONG>Name</STRONG></TD><TD><STRONG>F</STRONG></TD><TD><STRONG>M</STRONG></TD></TR><TR><TD>KATIE</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>LOUISE</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>JANE</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>JACLYN</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>LILLIE</TD><TD>F</TD><TD>&nbsp;</TD></TR><TR><TD>TIM</TD><TD>&nbsp;</TD><TD>M</TD></TR><TR><TD>JAMES</TD><TD>&nbsp;</TD><TD>M</TD></TR><TR><TD>ROBERT</TD><TD>&nbsp;</TD><TD>M</TD></TR></TBODY></TABLE><P><SPAN>Table 2:</SPAN></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><STRONG>Count_F</STRONG></TD><TD><STRONG>Count_M</STRONG></TD></TR><TR><TD>5</TD><TD>3</TD></TR></TBODY></TABLE> Sat, 10 Jun 2023 23:32:27 GMT https://community.jmp.com/t5/Discussions/JSL-count-quot-F-quot-and-quot-M-quot-characters-in-a-column/m-p/395902#M64661 ileshem 2023-06-10T23:32:27Z https://community.jmp.com/t5/Discussions/JSL-count-quot-F-quot-and-quot-M-quot-characters-in-a-column/m-p/395910#M64662 <P>Use&nbsp;</P> <P>&nbsp; &nbsp; &nbsp;Tables=&gt;Summary</P> <P>and select both columns F and M specifying the statistic N</P> <P>It will create a new data table</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_0-1624571127255.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/33783i8F667B5EE0195B24/image-size/medium?v=v2&amp;px=400" role="button" title="txnelson_0-1624571127255.png" alt="txnelson_0-1624571127255.png" /></span></P> <P>&nbsp;</P> Thu, 24 Jun 2021 21:45:36 GMT https://community.jmp.com/t5/Discussions/JSL-count-quot-F-quot-and-quot-M-quot-characters-in-a-column/m-p/395910#M64662 txnelson 2021-06-24T21:45:36Z