Hello,

I have a file

12 SRV1 GRP1
19 SRV1 GRP1
19 SRV1 GRP2
3 SRV1 GRP1
3 SRV1 GRP2
30 SRV1 GRP2
7 SRV1 GRP1
8 SRV1 GRP3

I want output like

41 SRV1 GRP1
52 SRV1 GRP2
8 SRV1 GRP3

Basically I want to calculate the count of first column based on other 2 columns.

Thanks in advance.

Something like that ?

awk '
{ sum[$2 OFS $3] += $1 }
END { for (f in sum) print sum[f],f }
' inputfile > outputfile

Jean-Pierre.