trying to use row and column in formulas

utzefke

New member
Joined
Aug 1, 2017
Messages
2
Reaction score
0
Points
0
i would like to know how to write a formule that adds column 2 in row 2 to column 3 in row 2. Or two fixed columnumbers in a variable row.

like :

for every row add column 2 in that row to column 3 in that row.

But i would like to do it with Sum and using Row and Column.

Could someone please help me?
 
Maybe misunderstanding, but you could switch to R1C1 style and use

=SUM(RC2:RC3)
 
Back
Top