To sum a column in Excel, click the empty cell directly below the numbers and press Alt and the equals sign together. That runs AutoSum, which drops in a =SUM() formula covering the numbers above it, and pressing Enter shows the total. You can also type the formula yourself, for example =SUM(B2:B100), or select the column and read the total off the status bar at the bottom of the window without writing anything at all. All three give the same answer; the shortcut is just the fastest.
Summing a column is often the first thing you do after converting a PDF to Excel, because adding up the amount column and checking it against the total printed on the original document is the quickest way to confirm the conversion captured every row. Here are the ways to sum, how to add only the rows you want, and why a sum sometimes comes back as zero.
How do you sum a column in Excel?
Select the cell just below the last number in the column, then click AutoSum on the Home tab or the Formulas tab, or press Alt and equals. Excel guesses the range of numbers above and writes =SUM(B2:B100) for you. Check that the highlighted range covers exactly the rows you want, then press Enter. If the guessed range is wrong, drag to reselect the cells before pressing Enter. To sum several columns at once, select the empty row beneath all of them first, then run AutoSum, and Excel fills a total under each column.
How do you sum an entire column in Excel?
Use a whole column reference: =SUM(B:B) adds every number in column B no matter how many rows you add later. This is handy for a growing list because you never have to widen the range. The catch is that the total cannot sit in column B itself, or Excel throws a circular reference error, so put it in another column or above the data. If your column has a header or the odd stray number you do not want counted, stick to a fixed range like =SUM(B2:B500) instead.
How do you see the sum of a column without a formula?
Select the cells you want to add and look at the status bar along the bottom edge of the Excel window. It shows the Sum, Average, and Count of the selection automatically, so you can total a column in one click without leaving a formula behind. Right click the status bar to switch on Minimum, Maximum, and other quick stats. This is the fastest way to sanity check a total, though it is read only, so use a real SUM formula when you need the number to stay on the sheet.
How do you sum a column based on a condition?
Use SUMIF for one condition or SUMIFS for several. To add only the amounts in column B where column A says "Rent", enter =SUMIF(A2:A100,"Rent",B2:B100). SUMIFS flips the order and takes many criteria, for example =SUMIFS(B2:B100,A2:A100,"Rent",C2:C100,">0") sums rent rows with a positive value in column C. These are the workhorses for totaling a category, a date range, or a single vendor out of a long converted statement without sorting or filtering the data first.
How do you sum only the visible rows after filtering?
A plain SUM adds hidden and filtered rows too, which quietly inflates the total. Use SUBTOTAL instead: =SUBTOTAL(9,B2:B100) adds only the rows left visible by a filter, and the 9 tells it to sum. If you want to ignore manually hidden rows as well as filtered ones, use =SUBTOTAL(109,B2:B100). AGGREGATE does the same job with more options. Reach for these whenever you are totaling a filtered view and the number needs to match what you can actually see on screen.
Which summing method should you use?
| Method | Best for |
|---|---|
| AutoSum (Alt and equals) | A quick total under a column |
| =SUM(B2:B100) | A fixed range you control |
| =SUM(B:B) | A column that keeps growing |
| Status bar | A read only check, no formula |
| SUMIF / SUMIFS | Totaling by category or date |
| SUBTOTAL(9, ...) | Summing filtered rows only |
Why is my Excel column sum showing zero or wrong?
The usual culprit is numbers stored as text. If the amounts came in from a converted or scanned document, Excel may treat them as text rather than numbers, and SUM skips text, so the total reads zero or looks too low. The giveaway is that the values sit left aligned in the cell and often carry a small green triangle in the corner. Select the range, click the warning icon, and choose Convert to Number, then the sum works. We walk through every fix in how to convert text to number in Excel. Other causes are hidden rows pulled in by a plain SUM, which SUBTOTAL solves, and a stray space or currency symbol trapped inside the value.
Use the column sum to check a PDF conversion
Once numbers are real numbers, summing the amount column is the fastest accuracy check there is. Add the column with AutoSum and compare the result to the total printed at the bottom of the original PDF. If they match to the cent, every row converted; if they are off, a row was dropped, split, or misread and you know to look closer. This one minute check is the core of how we judge how accurate a PDF to Excel conversion is, and it works best when the PDF to Excel converter keeps every figure in its own cell. The same tie out is how you would reconcile a stack of scanned receipts turned into expense totals before filing them.
The short version
AutoSum with Alt and equals is the fastest way to total a column, =SUM(B2:B100) gives you a fixed range, and =SUM(B:B) covers a growing one. Use SUMIF to total by category, SUBTOTAL to add only filtered rows, and the status bar for a no formula peek. If the sum comes back zero, your numbers are stored as text, and converting them fixes it. Summing the amount column and matching it to the printed total is the quickest way to prove a conversion is complete.