A | B | C | D | E | |
1 | Item name | Total Weight | lb | Criteria | lb |
2 | Dog lover | 40000 | =b2/e4 | Fish | 100 |
3 | So fishy | 20000 | =b3/e2 | Cat | 200 |
4 | Love bird | 30000 | =b4 | Dog | 300 |
5 | Super cat | 50000 | =b5/e3 | ||
6 | Big elephant | 1000 | =b6 | ||
7 | Small ant | 3000 | =b7 |
<tbody>
</tbody>
Hi, I need help for above tables.
How can I check if cells in column A contain criteria words in column E or not. And if it contains, I want the total weight on that cell divided by value of F column as shown on column C.
Thank you in advance.