Expliciting a sheet name with Strings

tfassnacht · 03/25/19

Hi all,

I would like to calculate the sum of elements in a column (say the 3rd columne) on another sheet.

The sheetname is in a column "NameSheet"

The following SUM("{" + NameSheet[1] + " Range 3}") does not return anything.

I know Excel has something like Indirect() and it would be SUM(INDIRECT("{" + NameSheet[1] + " Range 3}")) in Excel.

Could you help ?

Thanks.

Andrée Starå · 03/26/19

Hi,

Unfortunately, it's not possible at the moment, but it's a great idea!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Comments