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 vote293 views1 answer
Microstack no internet connection
Shell/Bash
0 vote307 views1 answer
Ffmpeg Sessiz ses üretin
Shell/Bash
10 votes287 views3 answers
Install mariadb
Shell/Bash
0 vote316 views1 answer
Raspberry remote
Shell/Bash
0 vote262 views1 answer
Debian copy directory
Shell/Bash
13 votes279 views4 answers
Composer install debian
Shell/Bash
1 vote297 views1 answer
Copy terminal preferences from one computer to another ubuntu
Shell/Bash
1 vote310 views1 answer
What is bin/bash
Shell/Bash
7 votes281 views3 answers
How to open file in linux
Shell/Bash
2 votes278 views1 answer
Aws cli ec2 list instances
Shell/Bash