Calculate totals in a range of text

[lliimu]

What function and formula would I use to calculate the
total of "M" (male) and "F" (female)listed in the same
column? I would like to have each total listed separately.

thks

 

[Ron Rosenfeld]

What function and formula would I use to calculate the
total of "M" (male) and "F" (female)listed in the same
column? I would like to have each total listed separately.

thks

=COUNTIF(rng,"M")
=COUNTIF(rng,"F")


--ron

 

[aorchard]

You could use count.if if you want to know the number of "M" and "F"; or you could use sum.if if you want to sum values according to the condition

AO