How To Do Sum In Google Sheets

Google Sheets is a versatile and powerful tool that millions of people use daily. One of the most frequently used functions is the “SUM”, which helps you add up numbers quickly. This blog post is aimed to walk you through the process of performing a sum function in Google Sheets.

Getting Started

To get started, first, open your Google Sheets document. You should have some numbers that you want to add up. If you don’t have any data, you can quickly create some for testing purposes.

Performing the SUM Function

Let’s say, for example, you have numbers in cells A1 to A5 and you want to find the sum of these numbers. Here’s how to do it:

The syntax for the sum function in Google Sheets is:

=SUM(value1, [value2, …])

For our example, to find the sum of numbers from cells A1 to A5, you would use the formula:


After entering this formula in the cell where you want the sum to be displayed (let’s say A6), press Enter. The sum of the numbers in cells A1 through A5 will then be displayed in cell A6.

Performing a Sum Across Sheets

You may also perform a sum across different sheets in Google Sheets. If you have numbers in the same cells across different sheets that you want to sum, here’s the formula you would use:

=SUM(sheet1!A1:A5, sheet2!A1:A5)

‘sheet1’ and ‘sheet2’ are the names of the sheets, and ‘A1:A5’ are the cells with the numbers you want to sum up. Change these to match your sheet names and cell ranges.


That’s how you can perform a sum function in Google Sheets! Whether you’re totaling up expenses, points, or any other numbers, the SUM function can be an incredibly useful tool. So next time you need to do some quick math, instead of pulling out your calculator, let Google Sheets do the work for you!