AWK: sum columns from multiple rows
2 min readNov 17, 2022
note: sed -n 1p
prints the first row
quote escape awk when using "
see awk looping, awk sum calculate, awk quoting
root@b1b309db3e99:/# cat /tmp/foo
1 (entrypoint.sh) S 0 1 1 0 -1 4210944 1312 1262 0 0 15 0 4 13 20 0 1 0 548927860 4079616 788 18446744073709551615 94337304551424 94337305274069 140724792565024 0 0 0 65536 4 81922 0 0 0 17 6 0 0 0 0 0 94337305505008 94337305552388 94337307742208 140724792569606 140724792569642 140724792569642 140724792569828 0
17 (cribl) S 1 1 1 0 -1 4210944 15773153 444193 3 0 37836 13014 198 1333 20 0 11 0 548927912 1122893824 56924 18446744073709551615 4194304 85350550 140731459827008 0 0 0 0 16781312 83458 0 0 0 17 0 0 0 0 0 0 87448600 87556120 93847552 140731459829462 140731459829490 140731459829490 140731459829731 0
18 (tail) S 1 1 1 0 -1 4210944 101 0 0 0 4 24 0 0 20 0 1 0 548927912 2613248 129 18446744073709551615 93889285218304 93889285258993 140728068151680 0 0 0 0 6 0 0 0 0 17 6 0 0 0 0 0 93889285282064 93889285284032 93889306365952 140728068157157 140728068157184 140728068157184 140728068157418 0
34 (cribl) S 17 1 1 0 -1 4210688 4589717 0 0 0 20948 5251 0 0 20 0 11 0 548928112 1158135808 57027 18446744073709551615 4194304 85350550 140728989394896 0 0 0 0 16781312 17922 0 0 0 17 6 0 0 0 0 0 87448600 87556120 101867520 140728989400435 140728989400515 140728989400515 140728989401059 0
root@b1b309db3e99:/# cat /tmp/foo|sed -n 1p|awk "{SUM+=\$14+\$15}END{print SUM/100}"
0.15
root@b1b309db3e99:/# cat /tmp/foo|sed -n 2p|awk "{SUM+=\$14+\$15}END{print SUM/100}"
508.5
root@b1b309db3e99:/# cat /tmp/foo|sed -n 3p|awk "{SUM+=\$14+\$15}END{print SUM/100}"
0.28
root@b1b309db3e99:/# cat /tmp/foo|sed -n 4p|awk "{SUM+=\$14+\$15}END{print SUM/100}"
261.99
root@b1b309db3e99:/# cat /tmp/foo|awk "{SUM+=\$14+\$15}END{print SUM/100}"
770.92