395902_en-US

liliconcom

JSL count "F" and "M" characters in a column

Hello,
I have this table 1 below and I want to summaries it by number of instances of "F" and "M" (Table 2).

How do I do that?

Thanks in advance.

Table 1:

Name	F	M
KATIE	F
LOUISE	F
JANE	F
JACLYN	F
LILLIE	F
TIM		M
JAMES		M
ROBERT		M

Table 2:

Count_F	Count_M
5	3

Data TableScriptingRe: JSL count "F" and "M" characters in a column

Use 

     Tables=>Summary

and select both columns F and M specifying the statistic N

It will create a new data table