With 3 columns how would I apply a formula to the first 2 and display the result in the 3rd?

Question

In Google Sheets I want to get the sum of the first 2 columns and display that result in the 3rd column all the way down. Like this:

I'm hoping for a solution that does this in one step. As I have many rows.

Edit: I am aware of this question: Apply formula to the entire column and it appears to only cover part of what I am asking.

@pnuts ...Oh. Answer my question so I can accept? – Nov 08 '16 at 23:42 — , Nov 08 '16 at 23:42

score 0 · Answer 1 · answered Nov 08 '16 at 23:37

0

Try:

=arrayformula(if(A2:A<>"",ADD(A2:A,B2:B),""))

answered Nov 08 '16 at 23:37

Ed Nelson

1 Answers1