Shell Programming and Scripting

Hi i have a file and i want to add the coloum values
like
9067 is coming twice here so o/p willbe like
9067,sum of 3rd coloum,sum of 4th coloum
9015 is coming 0nce then o/p
9015,15,6

sum is happening based on first coloum it will add all the third coloum and 4th coloum value where first coloum matches

a.txt
9067,AE,11,2
9061,AA,12,3
9003,AB,13,4
9067,AA,14,5
9015,AA,15,6
9061,AD,16,7

o/p
9067,25,8
9061,28,10
9003,13,4
9015,15,6

i am using nawk -F "," '{ a[$1]++ ; sum[$1] += $3 } END { for (k in sum) print k "," sum[k] "," a[k]}' a.txt
but is is giving o/p
9003,13,1
9015,15,1
9061,28,2
9067,25,2

pls let me know the correct code

You have done almost

Code:

 
 
awk -F "," '{ sum[$1] += $3;sum1[$1] +=$4 } END { for (k in sum) print k "," sum[k] "," sum1[k]}' a.txt