Cheat Sheet logoCheat Sheet Today
Linux sed and awk Cheat Sheet/Calculate an average

Compute the average of a numeric field.

Back to sheetBrowse commands
Sign in to save
Section: awk Filtering and Aggregation

Calculate an average

bash
bash
awk '{sum += $2; count += 1} END {if (count) print sum / count}' prices.txt
Explanation

Track totals and counts explicitly for derived values like averages.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing awk Filtering and Aggregation
Sum a numeric column
Add all values in the second 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