Awk sum if

# 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

26 votes225 views6 answers
Npm install
Shell/Bash
3 votes215 views3 answers
Kubectl delete all
Shell/Bash
7 votes228 views1 answer
Git reset head to remote
Shell/Bash
26 votes164 views12 answers
Spotify.com
Shell/Bash
0 vote219 views1 answer
Chnage the password of user n linu
Shell/Bash
0 vote197 views1 answer
Silent install google chrome
Shell/Bash
1 vote208 views1 answer
Node number id generator
Shell/Bash
0 vote199 views1 answer
Git fetch rebase
Shell/Bash
0 vote207 views1 answer
Linux mount lvm
Shell/Bash
3 votes204 views1 answer
How to stop a node server from running
Shell/Bash