Calculate totals in a range of text

  • Thread starter Thread starter lliimu
  • Start date Start date
L

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
 
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
Click to expand...

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


--ron
 
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
 
Back
Top