http://www.lyzasoft.com/support/category.php?catID=20 Lyzasoft Support Articles for the "Summary" category. http://www.lyzasoft.com/support/question.php?ID=116 http://www.lyzasoft.com/support/question.php?ID=116 Description Calculates the average of a numeric or date column. Syntax AVERAGECOLUMN(value, column1, column2, ...) Value is the column that contains the values you want to average. The column must... http://www.lyzasoft.com/support/question.php?ID=117 http://www.lyzasoft.com/support/question.php?ID=117 DescriptionCounts the values in acolumn.SyntaxCOUNTCOLUMN(value,column1, column2, ...)Value isthe column that contains the values you want to count. Value canbe a text, number, or date column.Column1,... http://www.lyzasoft.com/support/question.php?ID=118 http://www.lyzasoft.com/support/question.php?ID=118 Description Returns the first value from a column. Syntax FIRSTCOLUMN(value, column1, column2, ...) Value is the column that contains the value you want. The column can be a number, date, or text... http://www.lyzasoft.com/support/question.php?ID=119 http://www.lyzasoft.com/support/question.php?ID=119 Description Returns the last value from a column. Syntax LASTCOLUMN(value, column1, column2, ...) Value_column is the column that contains the value you want. The column can be a text, number, or... http://www.lyzasoft.com/support/question.php?ID=120 http://www.lyzasoft.com/support/question.php?ID=120 Description Returns the maximum value from a column. Syntax MAXCOLUMN(value, column1, column2, ...) Value is the column from which you want to find the maximum value. Value can be a text, number... http://www.lyzasoft.com/support/question.php?ID=121 http://www.lyzasoft.com/support/question.php?ID=121 Description Returns the minimum value from a column. Syntax MINCOLUMN(value, column1, column2, ...) Value is the column from which you want to find the minimum value. Value can be a text, number... http://www.lyzasoft.com/support/question.php?ID=122 http://www.lyzasoft.com/support/question.php?ID=122 Description Calculates the sum of values in a column. Syntax SUMCOLUMN(number, column1, column2, ...) Number is the column that contains the values you want to sum. Number must be a number colum... http://www.lyzasoft.com/support/question.php?ID=229 http://www.lyzasoft.com/support/question.php?ID=229 DescriptionCounts the distinct values in a column.SyntaxCOUNTDISTINCTCOLUMN(value, column1, column2, ...)Value is the column that contains the values you want to count. Value can be a text, number, or... http://www.lyzasoft.com/support/question.php?ID=230 http://www.lyzasoft.com/support/question.php?ID=230 DescriptionReturns the median value from a column.SyntaxMEDIANCOLUMN(value, column1, column2, ...)Value is the column from which you want to find the median value. Value can be a number or date column... http://www.lyzasoft.com/support/question.php?ID=231 http://www.lyzasoft.com/support/question.php?ID=231 DescriptionReturns the standard deviation of a column.SyntaxSTDEVCOLUMN(value, column1, column2, ...)Value is the column from which you want to find the standard deviation. Value can be a number or da...