How to Sum Multiple Columns in Google Sheets
If you’re looking to Sum Multiple Columns in Google Sheets, you have landed at the right place.
First, here’s a quick video featuring both methods:
Now, here’s a detailed explanation of the Google Sheets formula to Sum Multiple Columns:
#1 – By using SUM function
=SUM(B2:E2)
- The formula uses the SUM function, which is used to add up a range of cells.
- The cell range B2:E2 specifies the columns to sum. This will add up the values in columns B, C, D, and E for row 2.
- The formula does not need to be modified for other rows. It will automatically update to include the correct cell range for each row.
#2 – By using SUM function on multiple ranges
=SUM(B2:D2, F2:H2)
- The formula uses the SUM function, which is used to add up a range of cells.
- The formula sums two ranges, separated by a comma. Each range is separated by a colon and specifies the columns to sum. This will add up the values in columns B, C, and D, and then add up the values in columns F, G, and H for row 2.
- The formula does not need to be modified for other rows. It will automatically update to include the correct cell ranges for each row.
That’s it.
Other cool Google Sheets formulas:
- Google Sheets Formula to Split Text into Different Columns
- Google Sheets Formula to Find the Nth Largest Value
- Google Sheets Formula to Calculate the Weighted Average
And if you get stuck somewhere while applying the GSheets formula to Sum Multiple Columns, kindly let me know in the comments below.