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 .