When you only have a few thousand lines, a spreadsheet software will do. But when you got millions, it’s another job.
Unix has the awk
command, which you might not use too often, if at all, but is both powerful and easy get started with.
See here how to sump up all numbers in the 3rd column in records.csv
:
awk -F',' '{sum+=$3} END {print sum}' records.csv