You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.

There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.