Subtotal returns a subtotal in a list or database; it can be used repeatedly in the same column for subtotals and can be used again for the grand total. Sum adds all the numbers in a range of cells.