You can use the Sum function in Microsoft Office Excel to sum columns of data, whether your data is in an Excel table or is simply a range in a column of your worksheet. The sum of a column of ...

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

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.