You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers.
Use the SUM function in Excel to sum a range of cells, an entire column or non-contiguous cells. To create awesome SUM formulas, combine the SUM function with other Excel functions.