how to get total of certain categories in google sheets code example Example: sum by name in google sheets =SUM(FILTER($B$2:B;$A$2:A="VALUE YOU WANT TO GROUP BY"))