Sum values of columns into adjacent column

google-sheets sum google-sheets-formula
Mohamed Islam Fares picture Mohamed Islam Fares · Jan 19, 2015 · Viewed 13.8k times · Source

How can I add values in columns (T,U,V) and put the result in each adjacent cell in column S?

Example:

sample

Answer

Cameron Roberts picture Cameron Roberts · Jan 19, 2015

In the top column S cell where you want the result, enter the formula =SUM(T1,U1,V1) replacing row number "1" with the row number on which you are entering the formula.

Then, copy (ctrl-c) the cell containing the formula, and paste it into the cells in column S below.

When you copy & paste a formula, the spreadsheet will automatically adjust the row numbers according to where the formula is pasted.

Note, it will also adjust the Column letters, but in your case this is not relevant, since your Column positions are constant.

See the SUM formula documentation here: https://support.google.com/docs/answer/3093669

Related questions

Sum of row n through last row

I want to create a TOTAL row at the top of my spreadsheet. In this row, each cell should be the SUM of the values in the column below the TOTAL row. So for example, if the total row is …

Read More
SUMIF not strikethrough

Is is possible with Google Sheets to calculate the fields (currency) and ignore all fields that have had a strikethrough applied?

Read More
How to highlight cell if value duplicate in same column for google spreadsheet?

I am looking for formula for google spreadsheet highlight cell if value duplicate in same column can anyone please assist me for this query?

Read More