Spreadsheet: 711696d1609853488-office-365-formula-wont-calculate-in-2016-sampleformula-1-
Sheet: Data

Area | [NAME] ipsum copy | [NAME] ipsum copy2 | [NAME] ipsum copy3 | [NAME] ipsum copy4 | [NAME] ipsum [NAME] | [NAME] ipsum copy6 | Time | [NAME] ipsum copy7 | [NAME] ipsum copy8 |  |  |  |  | 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:45 PM | 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 |  |  |  |  |  | B5 | B3 | B1
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