The formula is only counting the RA in parentheses. That string will return 1 to the count because the RA is in parentheses. If you take the ra out of the names, it will still return 1 because of the RA in parentheses, which is what you said you wanted to count.

**Sheet1**
* | A | B | C |

1 | Connor, Sah (1234567) Bnson (RD, RA, FSFB) | * | 1 |

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:305px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>

</tbody>

**Spreadsheet Formulas** |

Cell | Formula | C1 | =COUNTIF(A1:A100,"*(*RA*)") |
<tbody>
</tbody> |

<tbody>

</tbody>

**Excel tables to the web >> ** Excel Jeanie HTML 4
**Sheet1**
| A | B | C |

1 | Connor, Sarah (1234567) Branson (RD, RA, FSFB) | | 1 |

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:305px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>

</tbody>

**Spreadsheet Formulas** |

Cell | Formula | C1 | =COUNTIF(A1:A100,"*(*RA*)") |
<tbody>
</tbody> |

<tbody>

</tbody>

**Excel tables to the web >> ** Excel Jeanie HTML 4