google spreadsheet functions sum function code example

Example: sum by name in google sheets

=SUM(FILTER($B$2:B;$A$2:A="VALUE YOU WANT TO GROUP BY"))