2] Sum a Column in Excel using AutoSum feature Another great way to calculate sums in a column is to make use of the AutoSum feature. It is quite useful, so let us explain what needs to be done.