Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
When in ColumnC B can be returned with =char(Column()+63) and since not inside double quotes this will automatically adjust to C in ColumnD. This way a string acceptable to INDIRECT can be construc...
Answer
#3: Post undeleted
by
Alexei
·
2021-05-26T18:09:12Z (over 3 years ago)
#2: Post deleted
by
pnuts
·
2021-05-24T06:41:46Z (over 3 years ago)
#1: Initial revision
by
pnuts
·
2020-10-23T15:10:05Z (about 4 years ago)
When in ColumnC `B` can be returned with `=char(Column()+63)` and since not inside double quotes this will automatically adjust to `C` in ColumnD.
This way a string acceptable to INDIRECT can be constructed in C16 that should produce the same result as the current formula in C16 and also, unlike the current formula, copy across to display the relevant result:
=SUM(INDIRECT($A17&"!"&char(column()+63)&"$2:"&char(column()+63)))
Since relying on [COLUMN](https://support.google.com/docs/answer/3093373 ) and [CHAR](https://support.google.com/docs/answer/3094120) this is limited to referencing the columns with single character references (ie the first 26).