How To Calculate Total In Excel?

Use the SUM function: `=SUM(A1:A10)`

Select the cell where you want the total

Type `=SUM(` and highlight the range of cells

Press Enter to calculate the total

Use AutoSum by clicking the `Σ` button

Select the cells above or beside the total cell

Press Enter to insert the total automatically

Add non-adjacent cells with `=SUM(A1,A3,A5)`

Include multiple ranges with `=SUM(A1:A5,C1:C5)`

Use the status bar to see a quick total after selecting cells

Copy the formula to total other rows or columns

Use `=SUBTOTAL(9,A1:A10)` for filtered data

Use `=SUMIF(range, criteria, sum_range)` for conditional totals

Use `=SUMIFS(sum_range, criteria_range1, criteria1)` for multiple conditions

Suggested for You

Trending Today