Adding elements, like columns, is one of the many features you can make use of in Google Sheets. Even inside columns, you can add formulas like Sum to quickly calculate the total data. This is a very handy time-saving tool. In this article, we will talk about the many ways we can sum a column.
How to Sum a Column in Google Sheet?
We can add values to our Google Sheet using various methods. Depending on the data size, you can use the following approaches.
Using SUM Function (Fx)
A function is a pre-established formula tab that you can use to sum, count, calculate average, and determine maximum and minimum multiple values at once. It isn’t just limited to simple mathematical equations; you can do much more than that. It lets you calculate and store data at the same time.
On PC
On Mobile
To add values using the sum function, follow the steps mentioned below.
Using the Formula
Using formulas is another way you can add values to your Sheet. The formula to sum is almost the same in all spreadsheet software. Let’s see how you can do it properly in your Google Sheet.
On PC
If you need to include values from a column where you need to skip a cell or two, you can use comma and colon keys to differentiate it.
On Mobile
Your sum should appear if you follow this exact process; however, it might take time if you input every cell name one by one. For longer data, you can try using a colon instead of a comma. You can also drag the end of the first Cell to the end if you don’t want to type in the cell name at all. This way, you can sum a column or even a row in Google Sheets to add multiple values.
