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.

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

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.