Hello,

I am basically a newbie using formulas in excel, so apologies if my question might be trivial !!

For grading my students, I have three possible grades, "R", "R-" and "NR". When there are two consecutive "R-", the second should be counted as a "NR".
I'd like to count the total of "R" plus "R-", taking into account the previous condition for two consecutive "R-".

Example:

R R NR R- R- R- R- NR R

the total should be 5 (the fifth and seventh values, "R-" would be counted as a "NR" because they are preceded by another "R-").

I am not sure if I managed to explain myself...

Is there a way to achieve this above ?

Thanks in advance !!!