How to Sum a Column in Google Sheets
Summing a column is one of the most common tasks in Google Sheets. There are multiple ways to do it, from quick status bar checks to automated formulas.
Use the Status Bar for a Quick Sum
Select the cells you want to sum. Look at the bottom-right corner of the Google Sheets window — the sum appears in the status bar automatically.
💡 Right-click the status bar to show or hide specific calculations.
Use the SUM Function
Type =SUM( in a cell, then select the range you want to sum. Press Enter. Example: =SUM(A1:A100).
Use AutoSum
Click the cell where you want the total. Click the Σ (Sigma) icon in the toolbar and press Enter. Google Sheets will automatically detect the range to sum.
💡 AutoSum works best when your data has no blank rows in the range.
Sum Across Multiple Sheets
Use =SUM(Sheet1!A:A, Sheet2!A:A) to add values from the same column across different sheets.
Try These Templates
Frequently Asked Questions
How do I sum only visible cells?
Use the SUBTOTAL function with function number 109: =SUBTOTAL(109, A1:A100) sums only visible cells.
How do I sum with conditions?
Use SUMIF for single conditions or SUMIFS for multiple conditions.