I have set up a form with google spreadsheet where I want to collect grocery spendings for different people. How can I sum spendings for different persons? Each row has a column with the person's name and the amount spent.
Let me give an example for the problem:
A B Name Amount Me 1 You 2 Me 3 Me 4 You 5
I want to SUM column B where column A = "Me" so the result is 8.