Google Sheets includes a built-in function named SUM to add the total value. There are two easy ways to utilize the SUM function.

SUM is one of the most useful functions in Google Sheets' arsenal, but sometimes you don't want the sum of every number in a range. Sometimes you need to be specific about which numbers you'll add ...

The formula to add multiple rows in Google Sheets is the same as the formula used in Excel. Type =SUM (cell range of first row, cell range of second row, cell range of third row, …) and hit Enter.