See the sum & average

Want to get more out of Google Docs for work or school? Sign up for a free Google Workspace trial.

You can quickly calculate the sum, average, and count in Google Sheets.

Note: This feature doesn’t work for some numbers or currency formats.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Highlight the cells you want to calculate.
  3. In the bottom right, find Explore Explore. Next to Explore, you'll see "Sum: total."
  4. To see more calculations, click Sum.
    • Average
    • Minimum
    • Maximum
    • Count
    • Count numbers
See an example
  A B
1 Student Grade
2 Student 1 90%
3 Student 2 88%
4 Student 3 75%
5 Student 4 95%


To find the average grade:

  1. Highlight the range B2:B5.
  2. In the bottom right, click Sum.
  3. Choose Avg.
  4. In the bottom right, you’ll see “Avg: 87%.”

Related articles

Was this helpful?
How can we improve it?