How can I use a formula to sum values below a certain word in a column. See example below where I need to sum all values just below the word dog:
<TBODY>
</TBODY>
35</SPAN> | ||
dog</SPAN> | ||
54</SPAN> | ||
34</SPAN> | ||
33</SPAN> | ||
12</SPAN> | ||
dog</SPAN> | ||
20</SPAN> | ||
cat</SPAN> | ||
12</SPAN> | ||
cow</SPAN> | ||
90</SPAN> | ||
23</SPAN> | ||
Total:</SPAN> | 74</SPAN> | expected result for dog |
<TBODY>
</TBODY>