Google Sheets is a great tool for basic calculations. However, if you want to see basic calculations without formulas, you can use the built-in functions in Google Sheets. To start, open Google Sheets and type “calculate” into the search bar. Then, select the function that you want to use. For example, if you want to calculate the square root of a number, type “sqrt” into the search bar and click on the button. You will then be taken to a page with all of the results for that function. To calculate a specific value, just enter it into the field that is associated with that function and click on the button.


Are there times when you want to see a quick sum or average of your data, but don’t necessarily need the formula result in your spreadsheet? In Google Sheets, you can select the cells and see basic calculations without formulas.

View Basic Calculations in Google Sheets on the Web

Like in Excel, finding these simple calculations takes only a glance in Google Sheets.

RELATED: How to Calculate the Sum of Cells in Excel

Head to Google Sheets, sign in, and open your spreadsheet. Select the cells you want to calculate. These can be adjacent or non-adjacent cells. Then, simply look down to the bottom right of the Google Sheets screen and you’ll see the Sum.

You can also view other helpful calculations and numbers here. Click the arrow in the window containing Sum and choose from Average, Minimum, Maximum, Count, or Count Numbers.

If you do choose another calculation and want to use it for another group of cells, that option will remain selected at the bottom. So you can simply select your other cell range or group and you’ll see the calculation display.

View Basic Calculations in Google Sheets in the Mobile App

You can view the same calculations in the Google Sheets mobile app. In fact, you have an added benefit on your mobile device because you can pop the formula you see into your sheet if you prefer.

Launch Google Sheets on your iPhone, iPad, or Android device and open your spreadsheet. Select the cells you want to calculate. Look down to the bottom of the sheet and you’ll see those same basic calculations in a row. Swipe right to view them all.

To add the formula to your sheet, tap it, and it will display in the cell at the end of the cell range. You can also tap a different formula and it will replace the first.

To add the formula in a specific cell in your sheet, select, hold, and drag it from the bottom row to the cell where you want it. Release and the formula will apply.

If it’s other operations you need, learn how to divide or multiply numbers in Google Sheets.