Calculate the Sum of a Column Using the “Awk” Script in Bash

When the data is stored in a file in a tabular format that contains one or more columns of the numeric data and if it requires to calculate the sum of a column with the numeric data, the “awk” script can be used to do this task. The “awk” script is used in Bash for many purposes. The uses of the “awk” script in Bash to calculate the sum of a column are shown in this tutorial.

Different Examples of Calculating the Sum of Column

The “awk” command can be used in different ways to calculate the sum of a column from a file that contains numeric data. The file can be a CSV file or a text file. Different ways of calculating the sum of a column are shown in this part of the tutorial.

Example 1: Calculate the Sum of a Column Using the Simple “Awk” Command
Create a text file named “courses.txt” with the following data. The second column of this file contains numeric data and the file does not contain any heading data:

Create a Bash file with the following script that takes the filename from the user. If the filename matches with the “courses.txt” file, the sum of the values of the second column from this file is calculated using the “awk” command. The “awk” command is used with the “cat” command here to read the content of the second column of the “courses.txt” file. Then, the summation value is printed.

The following output shows the sum of 2.0+1.0+3.0+2.0 which is 8.0:

Example 2: Calculate the Sum of a Column Using the Simple “Awk” Command with NR
Create a CSV file named “employees.csv” with the following data. The third column of this file contains numeric data and the file contains the heading data:

Create a Bash file with the following script that takes the filename from the command-line argument. If the filename matches with the “employees.csv” file, the sum of the values of the third column excluding the heading from this file is calculated using the “awk” command. The “awk” command uses the “NR” value here to omit the heading of the third column of the file. Then, the summation value is printed.

The script is executed twice in the following output. The script is executed without any argument in the first execution, so the error message is printed. The script is executed with a valid argument value in the second execution, so the summation value is printed:

Example 3: Calculate the Sum of a Column Using the Simple “Awk” Command with FS
Create a text file named “sales.txt” with the following data. The “:” is used in the file to separate the column and the second column of this file that contains the numeric data. The file does not contain any heading data.

Create a Bash file with the following script that takes the filename from the user. If the filename matches with the “sales.txt” file, the sum of the values of the second column from this file is calculated using the “awk” command. The “awk” command is used with the “FS” value here to define the field separator between the columns of the file. Then, the summation value is printed.

The following output appears if “sales.txt” is taken as input:

Conclusion

Multiple ways of calculating the sum of a column from a file using the “awk” command are shown in this tutorial.