Is there a way to search all repeat tables for a field mentioning a certain word like "Rabbit" and count how often that is mentioned and display that total sum?
There are lots of ways you could do this using Python, Arcade, etc, but are you looking to do it in a particular way? Or on a certain application?
If this is a select_one/select_multiple, this is super easy:
If this is a text field, you will need a script.