sum by name in google sheets

  1. Open your Google Sheets document.

  2. In an empty column, enter the formula to extract the names. Assuming the names are in column A, use the formula: =UNIQUE(A2:A) Drag the formula down to cover all relevant cells.

  3. In the adjacent column, next to the unique names, use the SUMIF function to sum values based on the names. Assuming the amounts are in column B, and the unique names start in column C, use the formula: =SUMIF(A:A, C2, B:B) Drag the formula down to cover all unique names.

  4. The new column with the summed values now contains the total sum for each unique name.

Note: Adjust the column references based on the actual location of your data in your Google Sheets document.