In this scenario I would like column C to show 0 for any cell in column a
that contains the word "dogs."

a b c c should be
1 xx dogs 33 0
2 rr cat 16 16
3 zz dogs 5 0

Thank you.