Hi I’ve some problems with calculating this kind of formula:
=SUM(Tabela3306496[#this row])
this works fine: SUM(Tabela3306496[]) but calculates the sum of a complete table. how to refer to the particular row?
PS. Using latest version of libre office 6.4
What are the square brackets meant to mean?
Trying to add “this row completely” would always return Err:523 because of the implicit self reference.
Summing the equally numbered row in a different sheet, say ‘OtherSheet’ is done with SUM($OtherSheet.2:2) if the cell containing the formula is in row 2 of its sheet e.g. The “2” will automatically adapt on Paste or Fill as needed due to the “relative addressing” used for the row.
The stated formula works well for Ms excel. What I want to sum up is not the complete row but only the cells in a row of a defined range which name is “Tabela3306496”. Any ideas?