Hello,
Is it possible to access a specific column, row, cell within named range?
For example sheet1:
A B C D 1 Col1 Col2 Col3 2 Row1 11 12 13 3 Row2 21 22 23 4 Row3 31 32 33
range1 == sheet1.$A$1:$C$3
- How can I sum Col2 within that range?
- How can I access Col2, Raw2's value?
Within the same sheet I can sum(‘Col2’)
I cannot do the same within different sheet.
Is there any way to do this using range1 with some specifications such as # [] or anything else?
Excell seems to have a method to access these using range[[‘Row2’],[‘Col2’]], did not test.
Similar method within libreoffice?
Thanks!
Alon