Shell Programming and Scripting

GR1     1       4       7
GR1     2       5       8
GR1     3       6       9
GR2     11      14      17
GR2     13      16      19
GR3     1       3       5
GR3     2       4       6

awk '{a[$1]+=$2;b[$1]+=$3;c[$1]+=$4} END {for (i in a) {print i,a[i],b[i],c[i]}}' file

GR1 6 15 24
GR2 24 30 36
GR3 3 7 11

awk '
        {
                T[$1]
                for ( i = 2; i <= NF; i++ )
                        A[$1 FS i] += $i
        }
        END {
                for ( k in T )
                {
                        printf "%s", k
                        for ( i = 2; i <= NF; i++ )
                                printf "\t%d", A[k FS i]
                        printf "\n"
                }
        }
' file

awk '
        {
                T[$1]++
                for ( i = 2; i <= NF; i++ )
                        A[$1 FS i] += $i
        }
        END {
                for ( k in T )
                {
                        printf "%s", k
                        for ( i = 2; i <= NF; i++ )
                                printf "\t%2d,%6.2f", A[k FS i], A[k FS i]/T[k]
                        printf "\n"
                }
        }
' file