Spreadsheet: 840951d1693223568-use-lookup-function-to-total-all-cells-that-contain-text-mock1-2-
Sheet: Sheet2

Award Date | Award Year | Start Date | End Date | category Type | Category | totals | Company | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027
2018-02-01 00:00:00 |  | 2018-01-01 00:00:00 | 2019-03-31 00:00:00 | central public organisation | category2 | 94961 | [NAME]
2018-02-01 00:00:00 |  | 2018-01-01 00:00:00 | 2019-03-31 00:00:00 | central public organisation | category2 | 94961 | [NAME]
2018-01-23 00:00:00 |  | 2017-11-01 00:00:00 | 2019-04-30 00:00:00 | overseas other | category2 | 75301 | department2
2018-02-02 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-31 00:00:00 | overseas central public orgainisation | category2 | 116188 | department3
2018-02-08 00:00:00 |  | 2018-03-04 00:00:00 | 2020-03-03 00:00:00 | uk company,buying,purchasing company,central public organisation | category1 | 1658.77 | department3
2018-03-22 00:00:00 |  | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | central public organisation | category2 | 960.76 | [NAME]
2018-03-23 00:00:00 |  | 2017-10-01 00:00:00 | 2020-09-30 00:00:00 | UK company, buying, purchasing company | category1 | 110000 | [NAME]
2018-04-23 00:00:00 |  | 2018-09-01 00:00:00 | 2021-09-30 00:00:00 | central public organisation | category2 | 30000 | department2
2018-05-11 00:00:00 |  | 2017-09-01 00:00:00 | 2019-08-31 00:00:00 | research council | category2 | 121126.56 | [NAME]
2018-05-11 00:00:00 |  | 2017-09-01 00:00:00 | 2019-08-31 00:00:00 | research council | category2 | 65610.22 | [NAME]
2018-05-26 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-28 00:00:00 | research council | category2 | 7456.8 | [NAME]
2018-05-26 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-28 00:00:00 | research council | category2 | 286.8 | department3
2018-06-11 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-31 00:00:00 | central public organisation | category2 | 1092.13 | [NAME]
2018-07-03 00:00:00 |  | 2018-05-01 00:00:00 | 2019-04-30 00:00:00 | research council | category2 | 0 | department2
2018-06-02 00:00:00 |  | 2017-10-01 00:00:00 | 2021-03-31 00:00:00 | UK company, buying, purchasing company | category1 | 40868 | department3
2018-07-06 00:00:00 |  | 2017-03-01 00:00:00 | 2017-10-16 00:00:00 | uk Educational Institution | category2 | 11272 | department2
2018-07-11 00:00:00 |  | 2018-09-01 00:00:00 | 2020-10-17 00:00:00 | overseas company(non-european) | category1 | 7999.95 | [NAME]
2018-08-09 00:00:00 |  | 2018-04-23 00:00:00 | 2021-04-30 00:00:00 | central public organisation | category2 | 151014.15 | [NAME]
2018-08-09 00:00:00 |  | 2018-04-23 00:00:00 | 2021-04-30 00:00:00 | central public organisation | category2 | 302028.3 | [NAME]
2018-08-09 00:00:00 |  | 2018-04-23 00:00:00 | 2021-04-30 00:00:00 | central public organisation | category2 | 21573.45 | department3
2018-08-21 00:00:00 |  | 2018-01-01 00:00:00 | 2020-12-31 00:00:00 | central public organisation | category2 | 36000 | [NAME]
 |  |  |  |  |  |  |  |  | [NAME] | department2 | department3 | [NAME] | [NAME]
 | [NAME] | department2 | department3 |  | [NAME] | [NAME] | category1 | 2018
2018 |  |  |  |  |  |  |  | 2019
2019 |  |  |  |  |  |  |  | 2020
2020 |  |  |  |  |  |  |  | 2021
2021 |  |  |  |  |  |  |  | 2022
2022 |  |  |  |  |  |  |  | 2023
2023
 |  |  |  |  |  |  | category2 | 2018
 |  |  |  |  |  |  |  | 2019
 |  |  |  |  |  |  |  | 2020
 |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  | 2022
 |  |  |  |  |  |  |  | 2023