Spreadsheet: 710208d1608775276-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 |  | 04:45PM | 17:00:00 | 5:15PM
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
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
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
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
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
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
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
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]
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
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
[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