Menu
How can I add values in columns (T,U,V) and put the result in each adjacent cell in column S?
Example:
606
(1) Select the column name that you will sum based on, and then click the Primary Key button; (2) Select the column name that you will sum, and then click the Calculate > Sum. (3) Click the Ok button.
Click the cell below a column of adjacent cells or to the right of a row of adjacent cells. Then, on the HOME tab, click AutoSum, and press Enter. Excel adds all of the cells in the column or row.
We can sum multiple columns conditionally by specifying a criterion. We can do this with a formula that is based on the SUMPRODUCT function.
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
93
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
