COUNTIF for presence of string in parenthesis while excluding non-parenthetical presence

[VinceInVA]

Humble gratitude is offered to overlook my ignorance here.
I want to COUNT for the the presence of the "RA" in the parenthesis while not including the ra in Sarah's name.
The RA I want to count will always be Capitalized and in parenthesis.
EXAMPLE

Connor, John (8675309) Wilson (RA, FSET, HBBQ)
Connor, Sarah (123456) Wilson (RA, FlET, FSFB)

<tbody>
</tbody>

Thank you,
Vince

 

[Scott Huish]

=sumproduct(--isnumber(find("RA,",left(right(substitute(a1:a100,"(",rept(" ",255),2),255),254)&",")))

 

[VinceInVA]

I am not worthy....
You rock!

This seems to only increment on the presence of RA in the second set while disregarding any instance of ra within student name or teacher name.

You folks inspire me to learn!!!

Thank you,
Vince