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 vote104 views1 answer
N see apt-secure(8) manpage for repository creation and user configuration details. ubuntu
Shell/Bash
20 votes107 views2 answers
Install mongodb on m1
Shell/Bash
37 votes102 views6 answers
Install angular bootstrap
Shell/Bash
0 vote93 views2 answers
Bash remove first line
Shell/Bash
0 vote100 views1 answer
Wslcopy to system clipboard
Shell/Bash
0 vote101 views1 answer
Bundle uninstall old gems
Shell/Bash
0 vote110 views1 answer
Powershell add-type if not exists
Shell/Bash
0 vote94 views2 answers
Add role to node kubernetes
Shell/Bash
0 vote90 views1 answer
Change default path to open in termanl
Shell/Bash
1 vote96 views1 answer
Run mutiple sass files at once
Shell/Bash