The fastest way to total a column is AutoSum; for conditions use SUMIF or SUMIFS.
Do it with AI insteadClick below the column
Select the empty cell directly under the numbers.
Press AutoSum
Press Alt+= (or Home ▸ AutoSum) and hit Enter.
Add a condition (optional)
Use =SUMIF(range, criteria, sum_range) to total only matching rows.
=SUMIF(A2:A100, "East", B2:B100)The numbers are stored as text — convert them with VALUE or Text to Columns.