Spreadsheet: 96896d1296150559-referencing-different-formulas-from-different-cells-dummy-workbook-copy
Sheet: DL_H_NB_Vol Pivot Tables

CHANNEL | T
 | Data
FSS_HH_GRP1 | [NAME] | [NAME] | Mar-2010 | Apr-2010 | [NAME] | [NAME] | [NAME] | Aug-2010 | Sep-2010 | Oct-2010 | Nov-2010 | Dec-2010 | 2010 Total | Q1-2010 | Q2-2010 | Q3-2010 | Q4-2010 | H1-2010 | H2-2010 | Jan-2011
A: Successful Start | 783 | 821 | 1054 | 704 | 730 | 725 | 980 | 896 | 888 | 781 | 734 | 581 | 9677 | 2658 | 2159 | 2764 | 2096 | 4817 | 4860 | 147
B: Happy Housemates | 550 | 474 | 659 | 390 | 395 | 439 | 485 | 463 | 457 | 387 | 424 | 323 | 5446 | 1683 | 1224 | 1405 | 1134 | 2907 | 2539 | 94
C: Surviving Singles | 1232 | 1181 | 1478 | 1057 | 1101 | 1100 | 1393 | 1209 | 1223 | 1127 | 1091 | 796 | 13988 | 3891 | 3258 | 3825 | 3014 | 7149 | 6839 | 235
D: On the Bread Line | 667 | 675 | 771 | 487 | 523 | 576 | 645 | 626 | 529 | 535 | 560 | 384 | 6978 | 2113 | 1586 | 1800 | 1479 | 3699 | 3279 | 130
E: Flourishing Families | 2912 | 2880 | 3771 | 2888 | 3040 | 2712 | 3480 | 3194 | 3215 | 2764 | 2615 | 1810 | 35281 | 9563 | 8640 | 9889 | 7189 | 18203 | 17078 | 544
F: Credit-hungry Families | 2734 | 2599 | 3353 | 2503 | 2521 | 2219 | 2939 | 2612 | 2480 | 2188 | 2283 | 1580 | 30011 | 8686 | 7243 | 8031 | 6051 | 15929 | 14082 | 456
G: Gilt-edged Lifestyles | 1276 | 1275 | 1483 | 1093 | 1122 | 1151 | 1368 | 1333 | 1391 | 1178 | 1121 | 849 | 14640 | 4034 | 3366 | 4092 | 3148 | 7400 | 7240 | 207
H: Mid-life [NAME] | 2604 | 2549 | 3073 | 1945 | 2119 | 2200 | 2587 | 2418 | 2760 | 2235 | 2072 | 1645 | 28207 | 8226 | 6264 | 7765 | 5952 | 14490 | 13717 | 416
I: Modest Mid-years | 2426 | 2323 | 2680 | 1876 | 1921 | 1936 | 2271 | 2122 | 2371 | 1995 | 1890 | 1358 | 25169 | 7429 | 5733 | 6764 | 5243 | 13162 | 12007 | 379
J: Advancing Status | 2644 | 2556 | 2983 | 1779 | 1849 | 2051 | 2290 | 2132 | 2486 | 1981 | 1874 | 1533 | 26158 | 8183 | 5679 | 6908 | 5388 | 13862 | 12296 | 377
K: Ageing Workers | 2276 | 2130 | 2340 | 1425 | 1493 | 1493 | 1826 | 1711 | 1923 | 1539 | 1467 | 1103 | 20726 | 6746 | 4411 | 5460 | 4109 | 11157 | 9569 | 353
L: Wealthy Retirement | 3074 | 2877 | 3703 | 2169 | 2321 | 2432 | 2632 | 2550 | 2932 | 2473 | 2338 | 1900 | 31401 | 9654 | 6922 | 8114 | 6711 | 16576 | 14825 | 439
M: Elderly Deprivation | 1290 | 1153 | 1391 | 742 | 820 | 862 | 1085 | 978 | 1118 | 956 | 908 | 647 | 11950 | 3834 | 2424 | 3181 | 2511 | 6258 | 5692 | 181
Grand Total | 24468 | 23493 | 28739 | 19058 | 19955 | 19896 | 23981 | 22244 | 23773 | 20139 | 19377 | 14509 | 259632 | 76700 | 58909 | 69998 | 54025 | 135609 | 124023 | 3958
CHANNEL | A
 | Data
FSS_HH_GRP1 | [NAME] | [NAME] | Mar-2010 | Apr-2010 | [NAME] | [NAME] | [NAME] | Aug-2010 | Sep-2010 | Oct-2010 | Nov-2010 | Dec-2010 | 2010 Total | Q1-2010 | Q2-2010 | Q3-2010 | Q4-2010 | H1-2010 | H2-2010 | Jan-2011
A: Successful Start | 273 | 309 | 381 | 261 | 296 | 229 | 418 | 340 | 383 | 352 | 287 | 234 | 3763 | 963 | 786 | 1141 | 873 | 1749 | 2014 | 79
B: Happy Housemates | 193 | 172 | 232 | 135 | 122 | 146 | 174 | 157 | 159 | 152 | 161 | 111 | 1914 | 597 | 403 | 490 | 424 | 1000 | 914 | 38
C: Surviving Singles | 426 | 446 | 518 | 379 | 404 | 350 | 614 | 490 | 525 | 484 | 481 | 327 | 5444 | 1390 | 1133 | 1629 | 1292 | 2523 | 2921 | 122
D: On the Bread Line | 196 | 202 | 209 | 150 | 138 | 161 | 259 | 221 | 185 | 199 | 221 | 134 | 2275 | 607 | 449 | 665 | 554 | 1056 | 1219 | 69
E: Flourishing Families | 1129 | 1188 | 1527 | 1251 | 1224 | 979 | 1657 | 1423 | 1531 | 1331 | 1154 | 818 | 15212 | 3844 | 3454 | 4611 | 3303 | 7298 | 7914 | 275
F: Credit-hungry Families | 907 | 893 | 1181 | 883 | 903 | 747 | 1295 | 1106 | 1081 | 1004 | 1001 | 668 | 11669 | 2981 | 2533 | 3482 | 2673 | 5514 | 6155 | 216
G: Gilt-edged Lifestyles | 504 | 537 | 594 | 438 | 460 | 401 | 606 | 553 | 606 | 522 | 476 | 371 | 6068 | 1635 | 1299 | 1765 | 1369 | 2934 | 3134 | 94
H: Mid-life [NAME] | 896 | 927 | 1135 | 676 | 741 | 694 | 1094 | 965 | 1157 | 924 | 819 | 666 | 10694 | 2958 | 2111 | 3216 | 2409 | 5069 | 5625 | 176
I: Modest Mid-years | 886 | 916 | 1021 | 726 | 726 | 673 | 1033 | 914 | 1071 | 873 | 801 | 597 | 10237 | 2823 | 2125 | 3018 | 2271 | 4948 | 5289 | 192
J: Advancing Status | 879 | 902 | 990 | 562 | 555 | 598 | 919 | 767 | 995 | 714 | 686 | 529 | 9096 | 2771 | 1715 | 2681 | 1929 | 4486 | 4610 | 147
K: Ageing Workers | 640 | 661 | 673 | 406 | 406 | 388 | 662 | 523 | 714 | 538 | 490 | 372 | 6473 | 1974 | 1200 | 1899 | 1400 | 3174 | 3299 | 119
L: Wealthy Retirement | 771 | 750 | 907 | 530 | 558 | 525 | 797 | 716 | 855 | 730 | 583 | 473 | 8195 | 2428 | 1613 | 2368 | 1786 | 4041 | 4154 | 109
M: Elderly Deprivation | 289 | 257 | 283 | 144 | 181 | 174 | 333 | 263 | 321 | 275 | 244 | 188 | 2952 | 829 | 499 | 917 | 707 | 1328 | 1624 | 57
Grand Total | 7989 | 8160 | 9651 | 6541 | 6714 | 6065 | 9861 | 8438 | 9583 | 8098 | 7404 | 5488 | 93992 | 25800 | 19320 | 27882 | 20990 | 45120 | 48872 | 1693
CHANNEL | P
 | Data
FSS_HH_GRP1 | [NAME] | [NAME] | Mar-2010 | Apr-2010 | [NAME] | [NAME] | [NAME] | Aug-2010 | Sep-2010 | Oct-2010 | Nov-2010 | Dec-2010 | 2010 Total | Q1-2010 | Q2-2010 | Q3-2010 | Q4-2010 | H1-2010 | H2-2010 | Jan-2011
A: Successful Start | 219 | 239 | 295 | 179 | 177 | 196 | 200 | 228 | 192 | 159 | 181 | 137 | 2402 | 753 | 552 | 620 | 477 | 1305 | 1097 | 33
B: Happy Housemates | 183 | 130 | 194 | 123 | 123 | 132 | 121 | 131 | 128 | 102 | 110 | 68 | 1545 | 507 | 378 | 380 | 280 | 885 | 660 | 24
C: Surviving Singles | 369 | 332 | 393 | 282 | 273 | 288 | 305 | 306 | 309 | 278 | 267 | 183 | 3585 | 1094 | 843 | 920 | 728 | 1937 | 1648 | 38
D: On the Bread Line | 223 | 229 | 264 | 147 | 189 | 188 | 167 | 194 | 161 | 143 | 149 | 100 | 2154 | 716 | 524 | 522 | 392 | 1240 | 914 | 23
E: Flourishing Families | 657 | 666 | 848 | 562 | 619 | 599 | 618 | 643 | 587 | 464 | 483 | 349 | 7095 | 2171 | 1780 | 1848 | 1296 | 3951 | 3144 | 103
F: Credit-hungry Families | 792 | 742 | 917 | 576 | 644 | 527 | 625 | 610 | 523 | 480 | 486 | 361 | 7283 | 2451 | 1747 | 1758 | 1327 | 4198 | 3085 | 98
G: Gilt-edged Lifestyles | 361 | 339 | 405 | 306 | 301 | 319 | 318 | 349 | 368 | 250 | 272 | 197 | 3785 | 1105 | 926 | 1035 | 719 | 2031 | 1754 | 49
H: Mid-life [NAME] | 864 | 834 | 1007 | 581 | 674 | 735 | 707 | 722 | 784 | 615 | 632 | 450 | 8605 | 2705 | 1990 | 2213 | 1697 | 4695 | 3910 | 111
I: Modest Mid-years | 712 | 681 | 729 | 471 | 502 | 536 | 531 | 544 | 540 | 471 | 470 | 300 | 6487 | 2122 | 1509 | 1615 | 1241 | 3631 | 2856 | 75
J: Advancing Status | 1035 | 945 | 1090 | 647 | 711 | 817 | 777 | 736 | 771 | 664 | 634 | 523 | 9350 | 3070 | 2175 | 2284 | 1821 | 5245 | 4105 | 126
K: Ageing Workers | 989 | 910 | 974 | 587 | 635 | 645 | 677 | 699 | 671 | 528 | 571 | 402 | 8288 | 2873 | 1867 | 2047 | 1501 | 4740 | 3548 | 136
L: Wealthy Retirement | 1597 | 1476 | 1946 | 1083 | 1168 | 1285 | 1192 | 1268 | 1392 | 1134 | 1147 | 931 | 15619 | 5019 | 3536 | 3852 | 3212 | 8555 | 7064 | 223
M: Elderly Deprivation | 693 | 637 | 752 | 391 | 414 | 472 | 472 | 481 | 540 | 447 | 422 | 308 | 6029 | 2082 | 1277 | 1493 | 1177 | 3359 | 2670 | 75
Grand Total | 8694 | 8160 | 9814 | 5935 | 6430 | 6739 | 6710 | 6911 | 6966 | 5735 | 5824 | 4309 | 82227 | 26668 | 19104 | 20587 | 15868 | 45772 | 36455 | 1114
CHANNEL | W
 | Data
FSS_HH_GRP1 | [NAME] | [NAME] | Mar-2010 | Apr-2010 | [NAME] | [NAME] | [NAME] | Aug-2010 | Sep-2010 | Oct-2010 | Nov-2010 | Dec-2010 | 2010 Total | Q1-2010 | Q2-2010 | Q3-2010 | Q4-2010 | H1-2010 | H2-2010 | Jan-2011
A: Successful Start | 291 | 273 | 378 | 264 | 257 | 300 | 362 | 328 | 313 | 270 | 266 | 210 | 3512 | 942 | 821 | 1003 | 746 | 1763 | 1749 | 35
B: Happy Housemates | 174 | 172 | 233 | 132 | 150 | 161 | 190 | 175 | 170 | 133 | 153 | 144 | 1987 | 579 | 443 | 535 | 430 | 1022 | 965 | 32
C: Surviving Singles | 437 | 403 | 567 | 396 | 424 | 462 | 474 | 413 | 389 | 365 | 343 | 286 | 4959 | 1407 | 1282 | 1276 | 994 | 2689 | 2270 | 75
D: On the Bread Line | 248 | 244 | 298 | 190 | 196 | 227 | 219 | 211 | 183 | 193 | 190 | 150 | 2549 | 790 | 613 | 613 | 533 | 1403 | 1146 | 38
E: Flourishing Families | 1126 | 1026 | 1396 | 1075 | 1197 | 1134 | 1205 | 1128 | 1097 | 969 | 978 | 643 | 12974 | 3548 | 3406 | 3430 | 2590 | 6954 | 6020 | 166
F: Credit-hungry Families | 1035 | 964 | 1255 | 1044 | 974 | 945 | 1019 | 896 | 876 | 704 | 796 | 551 | 11059 | 3254 | 2963 | 2791 | 2051 | 6217 | 4842 | 142
G: Gilt-edged Lifestyles | 411 | 399 | 484 | 349 | 361 | 431 | 444 | 431 | 417 | 406 | 373 | 281 | 4787 | 1294 | 1141 | 1292 | 1060 | 2435 | 2352 | 64
H: Mid-life [NAME] | 844 | 788 | 931 | 688 | 704 | 771 | 786 | 731 | 819 | 696 | 621 | 529 | 8908 | 2563 | 2163 | 2336 | 1846 | 4726 | 4182 | 129
I: Modest Mid-years | 828 | 726 | 930 | 679 | 693 | 727 | 707 | 664 | 760 | 651 | 619 | 461 | 8445 | 2484 | 2099 | 2131 | 1731 | 4583 | 3862 | 112
J: Advancing Status | 730 | 709 | 903 | 570 | 583 | 636 | 594 | 629 | 720 | 603 | 554 | 481 | 7712 | 2342 | 1789 | 1943 | 1638 | 4131 | 3581 | 104
K: Ageing Workers | 647 | 559 | 693 | 432 | 452 | 460 | 487 | 489 | 538 | 473 | 406 | 329 | 5965 | 1899 | 1344 | 1514 | 1208 | 3243 | 2722 | 98
L: Wealthy Retirement | 706 | 651 | 850 | 556 | 595 | 622 | 643 | 566 | 685 | 609 | 608 | 496 | 7587 | 2207 | 1773 | 1894 | 1713 | 3980 | 3607 | 107
M: Elderly Deprivation | 308 | 259 | 356 | 207 | 225 | 216 | 280 | 234 | 257 | 234 | 242 | 151 | 2969 | 923 | 648 | 771 | 627 | 1571 | 1398 | 49
Grand Total | 7785 | 7173 | 9274 | 6582 | 6811 | 7092 | 7410 | 6895 | 7224 | 6306 | 6149 | 4712 | 83413 | 24232 | 20485 | 21529 | 17167 | 44717 | 38696 | 1151