Simple Awk-script to calculate sums of values (here in $2) grouped by some field (here $1)

sum.awk

#! /usr/bin/awk -f
# equivalent oneliner for aliases:  awk -F "|" '{group[$1] += $2} END{for (g in group) print group[g], "\t", g;}'
BEGIN {
	FS="|"
}
{
	group[$1] += $2
}
END {
	for (g in group)
		print group[g], "\t", g
}