Spreadsheet: 710224d1608786388-trying-and-failing-to-pivot-data-dynamic-formula-sampleformula
Sheet: Data

Area | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | Time | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | PIVOT |  |  |  |  |  | Function
B5 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 04:45 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | Column Labels
B6 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 04:45 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | 04:45 PM | 05:00 PM | 05:15 PM | Grand Total |  |  | 05:00 PM | 05:15 PM
B7 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 04:45 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  | Count of Area | 8 | 10 | 5 | 23
B10 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 04:45 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  |  |  |  |  |  | B6 | B4 | B9
B15 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 04:45 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  |  |  |  |  |  | B7 | B8 | B12
B16 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 04:45 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  |  |  |  |  |  | B10 | B11 | B14
B23 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 04:45 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | B5 | B3 | B1 |  |  | B15 | B13 | [NAME]
B3 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | B6 | B4 | B9 |  |  | B16 | B17
B4 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | B7 | B8 | B12 |  |  | B23 | B18
B8 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | B10 | B11 | B14 |  |  |  | B19
B11 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | B15 | B13 | [NAME] |  |  |  | B21
B13 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | B16 | B17 |  |  |  |  | B22
B17 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  | B23 | B18
B18 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  |  | B19
B19 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  |  | B21
B21 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  |  | B22
B22 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:00 PM | [NAME] ipsum copy | [NAME] ipsum copy
B1 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:15 PM | [NAME] ipsum copy | [NAME] ipsum copy
B9 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:15 PM | [NAME] ipsum copy | [NAME] ipsum copy
B12 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:15 PM | [NAME] ipsum copy | [NAME] ipsum copy
B14 | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:15 PM | [NAME] ipsum copy | [NAME] ipsum copy |  |  |  |  |  | 05:00 PM | 05:15 PM
[NAME] | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | [NAME] ipsum copy | 05:15 PM | [NAME] ipsum copy | [NAME] ipsum copy