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

0 vote164 views3 answers
Create htpasswd file for nginx (without apache)
Shell/Bash
0 vote178 views1 answer
Flutter doctor Xcode installation is incomplete; a full installation is necessary for iOS development.
Shell/Bash
0 vote163 views1 answer
Xampp install in linux fedora
Shell/Bash
2 votes168 views1 answer
Brew install jdk 8
Shell/Bash
12 votes172 views4 answers
Open a file in linux
Shell/Bash
2 votes161 views2 answers
Edit sshd_config
Shell/Bash
3 votes170 views2 answers
How to know screen resolution linux
Shell/Bash
-1 vote151 views4 answers
Ssh save password
Shell/Bash
2 votes168 views1 answer
Docker runlike
Shell/Bash
0 vote182 views1 answer
Show linux distro
Shell/Bash