# 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.