Bash conditional sum

# Basic syntax:
awk '{ if ( condition ) { sum += $field; }} END { print sum }' your_file
# Where:
#	- $field is the field to sum if the condition is true

# Example usage:
# Sum all fields of column 5 in your_file that don't have "*" in field 3
awk '{ if ($3 != "*" ) { sum += $5; }} END { print sum }' your_file
# Note, explicitly setting your_file's field delimiter with 
#	"BEGIN { FS="<input_delimiter>" };" might be needed for non-standard 
#	delimiters

Source: unix.com

Similar codes

1 vote338 views1 answer
Unarchive tar acrhive
Shell/Bash
13 votes310 views1 answer
Bitbucket change commit message
Shell/Bash
0 vote352 views1 answer
Proxmox download iso directly
Shell/Bash
1 vote333 views2 answers
Undo git file changes
Shell/Bash
1 vote329 views1 answer
Load a dump in postgres 12
Shell/Bash
0 vote306 views2 answers
Bash get path of script
Shell/Bash
1 vote308 views1 answer
Bash variable substitution
Shell/Bash
0 vote320 views2 answers
How to perform hdfs string search recursively in hdfs
Shell/Bash
3 votes321 views2 answers
Authy
Shell/Bash
0 vote367 views1 answer
Pip install hashlib
Shell/Bash