THE SHORT ANSWER To sum and subtract in Google Sheets, use the formula =SUM (x:y) or =MINUS (x,y) in the desired cells and input the relevant values. Press Enter to get the results.