Find Min, Max, Avg and Sum of column with a simple input. See usage example for more information

minmax.awk

#!/usr/bin/awk -f

# Usage example:
#  get all of first column: ./minmax awk data.txt
#  set a custom field separator (default: ,): ./minmax.awk -v fs=":" data.txt
#  get all of the fourth column: ./minmax.awk -v column="4" data.txt
#  get min of the first column: ./minmax.awk -v type="min" data.txt
#  get min of the fourth column: ./minmax.awk -v column="4" -v type="min" data.txt
#
#  valid "column": 1..no
#  valid "type": min, max, avg, sum

BEGIN	{
	# set field separator
	if (fs)
		FS=fs
	else
		FS=",";
}
!i++ {
    # reset variables on first match.
    min = 9999; max = 0; sum = 0;
}
{
	value = $column
	min = (min < value) ? min : value
	max = (max > value) ? max : value
	sum = (sum + value)
}
END {
	# reset min if no match
	min = (min == 9999) ? 0 : min
	
	# calculate average
	avg = sum / NR
	
	#return requests value	
	if (type == "min") 
		print min
	else if (type == "max")
		print max
	else if (type == "avg")
		print avg
	else if (type == "sum")
		print sum
	else
		printf "min:%.2f;max:%.2f;avg:%.2f;sum:%.2f;", min, max, avg, sum
	
}