Excel Counting

  • Thread starter Thread starter dgilman
  • Start date Start date
D

dgilman

New Excel user so please have patience with me.

Cell C2-C43 contain text references. They are FMC, or PMC, or NMC.

Cells 47 reads % FMC and 48 reads % PMC etc

I would like to know the percentage of craft FMC, PMC or NMC whil
keeping the text in the cells the same. Is there a way to have Exce
change FMC to a number so I can get a percentage? Or if there is just
better way altogether. Thanks in advance
 
=COUNTIF(C2:C43,"FMC")/COUNTA(C2:C43)
=COUNTIF(C2:C43,"PMC")/COUNTA(C2:C43)
=COUNTIF(C2:C43,"NMC")/COUNTA(C2:C43)

Format all as %s
 
One way

=ROUND(COUNTIF(C2:C43,"*FMC*")/COUNTA(C2:C43),2)

or if the strings are the only thing in the cells

=ROUND(COUNTIF(C2:C43,"FMC")/COUNTA(C2:C43),2)

I rounded to 2 decimals, format result as percentage
 
Back
Top