Linux sed and awk Cheat Sheet/Sum a numeric column

Add all values in the second field.

Section: awk Filtering and Aggregation

Sum a numeric column

bash
bash
awk '{sum += $2} END {print sum}' prices.txt
Explanation

Use the END block for final reporting after all input is processed.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing awk Filtering and Aggregation
Calculate an average
Compute the average of a numeric field.
OpenIn sheetbashsame section
Find the maximum value
Track the highest number in a field.
OpenIn sheetbashsame section
Print rows matching a condition
Show lines where column 3 is greater than 100.
OpenIn sheetbashsame section
Count rows by key
Count occurrences of the first field.
OpenIn sheetbashsame section
Print selected columns
Show the first and third whitespace-delimited fields.
OpenIn sheetbash1 tag match
Use BEGIN and END blocks
Print headers and footers around processed output.
OpenIn sheetbash1 tag match