Cheat Sheet logoCheat Sheet Today
Linux Pipelines, xargs, split, diff, and Practical Recipes Cheat Sheet/Sum a CSV column

Compute the total of a numeric CSV field after skipping the header.

Back to sheetBrowse commands
Sign in to save
Section: Practical Recipes

Sum a CSV column

bash
bash
awk -F, 'NR>1 {sum += $3} END {print sum}' sales.csv
Explanation

Great for quick ad hoc analysis without opening a spreadsheet.

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 Practical Recipes
Show most frequent error messages
Count and rank repeated lines in a log.
OpenIn sheetbashsame section
Show effective config lines only
Remove comments and blank lines from a config file.
OpenIn sheetbashsame section
Find the largest files in a tree
List the top 20 largest files by size.
OpenIn sheetbashsame section
Extract unique IP addresses
Print unique IPs from a log file.
OpenIn sheetbashsame section
Replace text across many files safely
Search files first, then edit in place.
OpenIn sheetbashsame section
Pass stdin items as arguments
Convert lines into command arguments.
OpenIn sheetbash