Google Sheets – Sum on Condition

google sheets

I have set up a form with Google Spreadsheet where I want to collect grocery expenses for different people. How can I sum the expenses 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:

Table:

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.

Best Answer

You can use the SUMIF function to calculate the total sum for each person.

If you enter the following formula in a cell you like, it will give you the total amount spent by "Me":

=SUMIF(A2:A6,"=Me",B2:B6)

where A2:A6 is the Range, "=Me" is the Criteria, and B2:B6 is the Sum_Range.

Related Topic