Dears

I want to count how many specific word is repeted in long string in one cell i will give you example

Red , green , red , blue , ,black ,green , red, red,

what i want to do is to count how many times the word red repeted starting from the right hand side till the fourth coma only not through the whole sting only till the fourth coma