Value Formulas – Aggregation further details

Aggregation Value Formulas allow values to be queried and returned into worksheet cells.  The Value Formula can use other cell values as filter criteria therefore enabling a very flexible report format.  The example shows a matrix of Value Formulas with Months across the rows and Account Numbers going down the rows with Totals formulas mixed in.

​