Build a SUM, a conditional SUMIF, or a multi-condition SUMIFS, with the range locked correctly so it survives being filled down.
Free, no signup, nothing to download. Results update as you type.
=SUM(C2:C500)Click the cell where you want the total, type that, and press Enter. Change C2:C500 to cover your own rows, or use C:C for the whole column so it never needs adjusting.
SUM(range) adds every number in the range and ignores text and blanks. SUMIF(criteria range, criteria, sum range) adds only the matching rows. SUMIFS(sum range, criteria range, criteria, ...) takes the sum range FIRST, which is the opposite of SUMIF and the single most common reason one of them returns zero.
The numbers are text. A column imported from another system often holds numbers stored as text, and SUM silently skips them rather than erroring. Left-aligned values in a column are the tell. Multiply by 1, or use Text to Columns, to convert them.
Usually argument order. SUMIF is (criteria range, criteria, sum range) but SUMIFS is (sum range, criteria range, criteria). If you learned one and typed the other, the formula still calculates and returns the wrong number rather than failing.
Yes if the formula gets filled down or across. Without them C2:C500 becomes C3:C501 on the next row, so each total quietly covers a different range. Whole-column references like C:C avoid the problem entirely.
The same numbers, live off the rows your team already edits, in a spreadsheet that rolls them up for you. Start your 7-day free trial, no credit card required.