help logoLON-CAPA Help

Summing up columns

To take the sum of column M, for example, use &SUM('M*')

Spreadsheet Lists

When you have a list of numbers in a cell, how it is displayed depends on how you separate the numbers and how Perl interprets the results.

35 45 12 will not generate any result because this is an invalid Perl statement.

35,45,12 will have a result of 12 because Perl has a comma operator similar to the comma operator in C.

The comma operator is binary and returns the value on its right. Thus $variable = 15, 26; assigns $variable the value 26. If you need the values to all be displayed as a string, enclose the entire cell contents in quote marks.