How To Add Up A Column In Excel?

Select the cell where you want the total to appear

Use one of these formulas:

`=SUM(A:A)` (adds the entire column A)

`=SUM(A1:A100)` (adds a specific range in column A)

`=SUM(B:B)` (adds the entire column B)

Press Enter

If needed, drag the fill handle to copy the formula to other totals

Suggested for You

Trending Today