An aggregate answer to two Excel questions

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