IF function working with LEN and Substitute

Hi

I have a formula that looks up the number of occurances of a single character in a column, some cells contain more than one character.

=SUM(LEN(range)-LEN(SUBSTITUTE(range,"A","")))

I want to add an IF function to this so that it will only carry out the above formula IF a certain word appears in another column of that same row? But then I don't want this to cancel out and return a 0 if the word does not appear in a row.

Row 1 Row 2
Red .........A
Blue..........A
Red .........A
Red......... A

For example with the above if the certain word was "red" it will only return a value of 3 as the 2nd column should not count.

Any help would be appreciated

Thanks