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

1 vote325 views1 answer
Install trading view on linux
Shell/Bash
1 vote412 views1 answer
The command could not be located because '/snap/bin' is not included in the PATH environment variable.
Shell/Bash
0 vote335 views1 answer
Linux check how many open files are allowed
Shell/Bash
0 vote386 views3 answers
Github/hacksofteare
Shell/Bash
24 votes332 views3 answers
Notepad++ linux
Shell/Bash
3 votes323 views2 answers
Update metasploit
Shell/Bash
1 vote339 views1 answer
Linux document root
Shell/Bash
0 vote348 views1 answer
Install radeon drivers ubuntu
Shell/Bash
1 vote355 views1 answer
Wget pause download
Shell/Bash
0 vote337 views1 answer
Brew install golang-migrate
Shell/Bash