If I need to sum the values of each ingredient, and some ingredients are sourced from multiple suppliers, what is the easiest way to do this?
Ingredient | Supplier | Volume |
Tomatoes | Johnson & sons | 200 |
Tomatoes | MD supplies | 150 |
Oranges | MD supplies | 10 |
Apples | Tom's Fresh fruit & Veg | 20 |