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

0 vote263 views1 answer
Windows launch node with multiple environment variables
Shell/Bash
0 vote250 views1 answer
Git clone if not exist or git pull
Shell/Bash
0 vote275 views1 answer
Second monitor after update went black
Shell/Bash
0 vote259 views1 answer
Npx hint shell: /bin/bash -e {0} env: FORCE_COLOR: 1 Cannot destructure property 'trackException' of 'utils_1.appInsights' as it is undefined. Error: Process completed with exit code 1.
Shell/Bash
2 votes290 views1 answer
Windows where are pip packages installed
Shell/Bash
0 vote267 views1 answer
Ignore .DS_store when uploading to s3 using shell
Shell/Bash
0 vote255 views1 answer
Generate 6 digit random number ruby
Shell/Bash
15 votes272 views2 answers
How to clear git status
Shell/Bash
2 votes281 views1 answer
How to change port apache2 ubuntu
Shell/Bash
0 vote269 views2 answers
Linux search string in source recursively
Shell/Bash