Get Sum, Average, and Counts From a CSV in Seconds

You have a CSV and a simple question: what does this column add up to? What's the average order value? Which row holds the highest number? In a spreadsheet that means typing =SUM(), picking a range, finding a spare cell to drop the result in — and waiting, if the file is large enough to make the app crawl. There's a faster way that needs no formula at all: open the file, select the cells, and read the answer.

The problem with =SUM() on a big file

For a small spreadsheet, a formula is fine. The friction shows up as the file grows.

You have to load the whole thing first. A spreadsheet can't compute =SUM(B:B) until it has read and rendered every row into a live cell. On a few-hundred-megabyte export that's gigabytes of RAM and a long "Not Responding" pause before you can even click. For more on that, see opening large CSV files.

The formula is overhead you don't need. To total a column you pick a function, select a range, and place the result somewhere — then repeat for the average, and again for the max. Every quick answer becomes three or four small chores, and you've now edited the file by adding helper cells you'll have to delete.

It recalculates while you work. Once formulas are in the sheet, every edit triggers a recalc pass. On a large file that turns a one-line change into another wait.

All of that to answer a question you could have read at a glance.

The faster way: select and read

CEESVEE is a free, open-source (MIT) CSV and delimited-file editor for Windows, macOS, and Linux. It keeps your data in a Rust core and draws only the rows on screen, so it opens files a spreadsheet chokes on. The payoff for quick answers is live selection statistics: highlight any range of cells and the status bar instantly shows the count, sum, average, min, and max of what you selected. No function, no range argument, no result cell — and nothing is uploaded, because everything runs on your machine.

What the status bar shows

Stat	What it tells you
Count	How many cells are in your selection — useful for counting non-empty entries.
Sum	The total of the numeric values selected.
Average	The mean of the numeric values selected.
Min	The smallest value in the selection.
Max	The largest value in the selection.

These update the moment your selection changes, so you can sweep across different ranges and watch the numbers follow.

Total a column in four steps

Say you have an orders export and you want the total of the Amount column.

1. Download CEESVEE and open the file — drag it onto the window or use File → Open. The delimiter and encoding are auto-detected, so a typical export opens with no setup.
2. Select the Amount values. Click the column header to grab the whole column, or click the first cell and drag (or shift-click the last cell) to select a specific range of rows.
3. Read the status bar. The sum is your column total. Right beside it sit the average, min, and max — so you've answered four questions with one selection.
4. Check the count. The count confirms how many cells you actually selected, a quick sanity check that you grabbed the rows you meant to.

That's the whole workflow. No formula was written and the file wasn't modified.

More questions, same trick

The same select-and-read approach answers the questions people usually reach for a formula to solve:

• Average a column: select it and read the average — no =AVERAGE() needed.
• Find the highest or lowest value: the min and max are already on screen the instant you select. To then jump to that row, a multi-column sort puts the extreme value at the top.
• Count non-empty cells: select a range and read the count to see how many entries you have.
• Spot-check a subset: select just the rows for one region or date and the stats recompute for that slice alone — handy for sanity-checking after a find and replace or an edit.

Because the selection is freeform, you're not limited to whole columns. Highlight a block of cells across several columns, or a handful of scattered rows, and the readout reflects exactly what's selected.

Why it stays fast

The reason this works on files that defeat a spreadsheet is the same reason CEESVEE opens them at all. The dataset lives in the Rust core rather than in millions of live interface cells, and the virtualized grid paints only the rows in view. Selecting cells and computing their stats happens in that core, so the numbers appear without the load-everything-first pause — even on a 1,000,000-row, 100 MB+ file. The frozen header row keeps your column names in sight while you scroll, and the row and column counts in the status bar tell you the shape of the file at a glance.

The bottom line

A sum, an average, a min, a max, a count — these are questions you should be able to answer by looking, not by writing formulas and waiting for a recalc. Open the CSV, select the cells, and read the live stats in the status bar. No formula language, no database load, no upload.

Download CEESVEE for free and get your numbers in seconds.