0

Let's say I've got a chart and I've got some numbers in the first couple columns. I want the next column, C, to have the numbers from the first two columns added together. I've tried using the ROW() attribute to do this, but I don't know how to apply it to specific columns, and it's tedious to write the column number for every time I want to do this.

Is there any way I can write a universal function that adds the two columns of a certain row together?

   | A | B  | C
  1|1.3|1.4 |=(this row's a column plus this row's b column)
  2|1.2|1.5 |=(this row's a column plus this row's b column)
  • 1
    Simply typing C1 = A1+B1 and copying the formula below should do the job. The references are relative, meaning they will refer to the correct entries in other rows. – user135384 Nov 29 '16 at 21:36
1

In C1 and copied down to suit:

=sum(A1:B1)

SUM

Or without copying down:

=ArrayFormula(A1:A+B1:B)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.