Bash command to sum specific columns of numbers from a file with many columns

Question

A  1  15  4
B  2  14  5
C  3  13  6
D  4  12  4

I would like to add columns 2 (1+2+3+4) and 3 (15+14+13+12) and eventually add them together, while ignoring columns 1 and 4. How can I accomplish this?

Incrivel Monstro Verde · Accepted Answer · 2020-05-13 16:19:11Z

3

sum columns 1, 3 and 1+3

awk 'BEGIN {FS = " "} ; {sum+=$2} {sum2+=$3} END {print sum, sum2, sum+sum2}'  file

answered May 13, 2020 at 16:19

Incrivel Monstro Verde

9487 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

connecttopawan · Accepted Answer · 2020-05-13 16:31:22Z

0

You can try below:

awk 'BEGIN {FS = " "} ; {sum+=$2} {sum1+=$3} END {print sum sum1}' file.txt

edited May 13, 2020 at 16:31

answered May 13, 2020 at 16:07

connecttopawan

2385 silver badges15 bronze badges

Collectives™ on Stack Overflow

Bash command to sum specific columns of numbers from a file with many columns

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related