summarizecolumns


Prev		Next

Name

summarizecolumns — Add the values from all columns that match the regular expression.

summarizecolumns(regex)

The SUMMARIZECOLUMNS function has the following argument:

This function will sum all numeric columns whose column name matches a specified regular expression pattern.

Formula	Description	Result
summarizeColumns('feature\\.Yield\\..*')	Sum the values of all columns whose names start with 'feature.Yield.':
summarizeColumns('feature\\.Seral\\.(Mature\|Old)\\.D')	Sum the values of all columns whose names start with 'feature.Seral.', are 'Mature' or 'Old', and end with '.D'