If you ever use Subtotals in Excel, if you ever wanted to sum only visible cells, make sure you checkout An aggregate answer to two Excel questions
An aggregate answer to two Excel questions
Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.