Addition and multiplication

[brendenasare]

What this code achieve is it sums up all entries in “Accepted Cherries” and multiplies it by the sum of all entries in “Price paid per kg of Cherries”

But what I am trying to achieve is multiply the “Accepted Cherries” by the “Price paid per kg of Cherries” for each farmer and then sum it up.
For instance the screenshot below should be calculated as
(10 x 50) + (9x400)

[rvanderarend]

Hi Brenden, this problem is not really specific to Alan, but I’ll answer it any way: the trick is to do the multiplication per line first and then take the sum of that result (something like ‘amount’). If you are first taking the sum of all the weights and prices, you add cherries with very different prices, that will not work.