adding sum for column google sheet code example
Example 1: google sheets add all numbers in a column with condition
=SUMIF(A5:A13,B1,B5:B13)
Example 2: sum by name in google sheets
=SUM(FILTER($B$2:B;$A$2:A="VALUE YOU WANT TO GROUP BY"))
=SUMIF(A5:A13,B1,B5:B13)
=SUM(FILTER($B$2:B;$A$2:A="VALUE YOU WANT TO GROUP BY"))