How to caltculate a total of a changing number of columns containing a certain string?

[LarsDellen]

Hi,

I need some help and cannot get my head around this.

I have a file that comes with a changing number of columns and I need to calculate the sum of those columns, that in the column name contain "CY".

[mot · Accepted solution]

Hi @LarsDellen,

You can transpose the data and have a filter that include the formula contains([ColumnNames], "CY"). Once you do that you can use Summarize to sum the values. I hope this helps.

Best!