Counting Occurrences of a Character for Specific Rows of a Dataset

[SteveQ]

Looking for a solution to count the number of occurences of a specific character in a dataset BUT only for specific rows.
I've used the following formula for counting the number of occurences of a specific character: =SUM(LEN(range)-LEN(SUBSTITUTE(range,"text","")))/LEN("text"). My question is how do I adjust that formula or use another formula to count those characters ONLY for specific rows. For example:
In the following dataset, the formula above counts the total number of occurences of "c" in columns B and C and yields 3 occurences.
What formula will count the total number of occurences of "c" asscociated with BOB (there are 2 occurences)?

 

[Domenic]

Try...

=SUM(IF(A1:A4="BOB",LEN(B1:C4)-LEN(SUBSTITUTE(B1:C4,"c","")))/LEN("c"))

or

=LET(data,FILTER(A1:C4,A1:A4="BOB",0),SUM(LEN(data)-LEN(SUBSTITUTE(data,"c","")))/LEN("c"))

Hope this helps!