# An aggregate answer to two Excel questions

- URL: https://dynamicaccounting.net/an-aggregate-answer-to-two-excel-questions/
- Date: 2012-01-10
- Topics: Excel & Office
- Type: link to an external article
- Source: http://www.journalofaccountancy.com/Issues/2012/Jan/ExcelAggregateFunction.htm

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](http://www.journalofaccountancy.com/Issues/2012/Jan/ExcelAggregateFunction.htm)

![](http://www.journalofaccountancy.com/content/dam/jofa/archive/issues/2012/01/techqa1.jpg)