Mac: The "Sum" function in spreadsheets is great, but if you're not the type to do all your list-making in Excel, coder Brett Terpstra built an OS X System Service that allows you to total up any ...

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.