• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

How do you add a row of cells in two columns into a third column?

Dari

Lifer
I know you can go to the first cell and do something like this in C1:
=SUM(A1:B1)

My problem is how do I extend this down without having to manually write this?
 
Originally posted by: ChAoTiCpInOy
Bottom right of the cell, drag it to wherever it is how far you want to go down.

Thanks. I figured that out shortly after posting this.
 
even better - if you double-left click in the lower left corner of the cell with the formula, it will auto-copy it down to every row with corresponding data in row B
 
Originally posted by: NeoV
even better - if you double-left click in the lower left corner of the cell with the formula, it will auto-copy it down to every row with corresponding data in row B

Thank you as well.
 
Back
Top