Spreadsheet: 172685d1344291483-sum-formula-not-working-working-capital-dashboard-working-formulas
Sheet: CALCS

 |  |  |  | 0
 | From |  |  |  | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00
 | To
 | Branch | 1 |  |  | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB
 | Working Capital | 1
 | Customer | 4 |  | From | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00
 | byQuarter | 2 |  | To
 | category | 1
 | From | To
 |  |  |  |  | Branch |  |  |  | Working Capital
1 |  |  | April 2011 | 1 | All | Check | Select | 1 | All | Check | Select
2 | 2011-05-01 00:00:00 |  | May 2011 | 2 | Branch 1 | True |  | 2 | Inventory | True
3 | 2011-06-01 00:00:00 |  | June 2011 | 3 | Branch 2 | True |  | 3 | Receivables | True
4 | 2011-07-01 00:00:00 |  | July 2011 | 4 | Branch 3 | True |  | 4 | Payables | True
5 | 2011-08-01 00:00:00 |  | August 2011 | 5 | Branch 4 | True |  | 5 | Intra Group | True
6 | 2011-09-01 00:00:00 |  | September 2011 | 6 | Branch 5 | True
7 | 2011-10-01 00:00:00 |  | October 2011 | 7 | Branch 6 | True
8 | 2011-11-01 00:00:00 |  | November 2011 | 8 | Branch 7 | True
9 | 2011-12-01 00:00:00 |  | December 2011 | 9 | Branch 8 | True
10 | 2012-01-01 00:00:00 |  | January 2012 | 10 | Branch 9 | True
11 | 2012-02-01 00:00:00 |  | February 2012 | 11 | Branch 10 | True
12 | 2012-03-01 00:00:00 |  | March 2012 | 12 | Branch 11 | True
13 | 2012-04-01 00:00:00 |  | April 2012 | 13 | Branch 12 | True
14 | 2012-05-01 00:00:00 |  | May 2012 | 14 | Branch 13 | True
15 | 2012-06-01 00:00:00 |  | June 2012 | 15 | Branch 14 | True
16 | 2012-07-01 00:00:00 |  | July 2012 | 16 | Branch 15 | True
17 | 2012-08-01 00:00:00 |  | August 2012
18 | 2012-09-01 00:00:00 |  | September 2012
19 | 2012-10-01 00:00:00 |  | October 2012
20 | 2012-11-01 00:00:00 |  | November 2012
21 | 2012-12-01 00:00:00 |  | December 2012 | Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
22 | 2013-01-01 00:00:00 |  | January 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SelectedRange | 12months prior
23 | 2013-02-01 00:00:00 |  | February 2013
24 | 2013-03-01 00:00:00 |  | March 2013
 |  |  |  | Inventory
 |  |  |  | Receivables
 |  |  |  | Payables
 |  |  |  | Intra Group