How to use Google Sheets formulas To input a formula into Google Sheets, preface what you type with the equal sign (=). Let's look at two examples to see the difference this makes. If we input 2 ...

To add a formula in Google Sheets, click the cell where you want the answer, then choose one of the hundreds of functions.

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. Adding up columns or rows of ...