Here is the formula i am using and it is working.
=SUMPRODUCT(--(($A$56:$A$300>=3))*(EXACT(S$56:S$300;"AE")+(EXACT(S$56:S$300;"BE")+(EXACT(S$56:S$300;"RB")))))
I have a value that has to be >=3 in A56:A300.
And i have two letter code in S56:S300 that might be AE, BE, qB, AB, BB, RB, PB ...