Summing data in columns

  • Thread starter Thread starter ElGordo
  • Start date Start date
E

ElGordo

I have data in letter form: M=male and F= female. I have tried SUMIF but cant
get a total of aal the "M"s or"F"s in a column.What am I doing wrong as the
help pages dont ma ke it clear?
 
Use Countif instead of Sumif.

Hope that this is what you are looking for…

Assume that you are having the Gender details in A Column.

A COL
M
F
M
F
M
M
F
M

=COUNTIF(A:A,"M")
=COUNTIF(A:A,"F")

If this post helps, Click Yes!
 
Back
Top