Spreadsheet: 840952d1693225420-use-lookup-function-to-total-all-cells-that-contain-text-mock1-2-1-
Sheet: Sheet2

Award Date | Award Year | Start Date | End Date | category Type | 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 | 94961 | [NAME]
2018-02-01 00:00:00 |  | 2018-01-01 00:00:00 | 2019-03-31 00:00:00 | central public organisation | 94961 | [NAME]
2018-01-23 00:00:00 |  | 2017-11-01 00:00:00 | 2019-04-30 00:00:00 | overseas other | 75301 | department2
2018-02-02 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-31 00:00:00 | overseas central public orgainisation | 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 | 1658.77 | department3
2018-03-22 00:00:00 |  | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | central public organisation | 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 | 110000 | [NAME]
2018-04-23 00:00:00 |  | 2018-09-01 00:00:00 | 2021-09-30 00:00:00 | central public organisation | 30000 | department2
2018-05-11 00:00:00 |  | 2017-09-01 00:00:00 | 2019-08-31 00:00:00 | research council | 121126.56 | [NAME]
2018-05-11 00:00:00 |  | 2017-09-01 00:00:00 | 2019-08-31 00:00:00 | research council | 65610.22 | [NAME]
2018-05-26 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-28 00:00:00 | research council | 7456.8 | [NAME]
2018-05-26 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-28 00:00:00 | research council | 286.8 | department3
2018-06-11 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-31 00:00:00 | central public organisation | 1092.13 | [NAME]
2018-07-03 00:00:00 |  | 2018-05-01 00:00:00 | 2019-04-30 00:00:00 | research council | 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 | 40868 | department3
2018-07-06 00:00:00 |  | 2017-03-01 00:00:00 | 2017-10-16 00:00:00 | uk Educational Institution | 11272 | department2
2018-07-11 00:00:00 |  | 2018-09-01 00:00:00 | 2020-10-17 00:00:00 | overseas company(non-european) | 7999.95 | [NAME]
2018-08-09 00:00:00 |  | 2018-04-23 00:00:00 | 2021-04-30 00:00:00 | central public organisation | 151014.15 | [NAME]
2018-08-09 00:00:00 |  | 2018-04-23 00:00:00 | 2021-04-30 00:00:00 | central public organisation | 302028.3 | [NAME]
2018-08-09 00:00:00 |  | 2018-04-23 00:00:00 | 2021-04-30 00:00:00 | central public organisation | 21573.45 | department3
2018-08-21 00:00:00 |  | 2018-01-01 00:00:00 | 2020-12-31 00:00:00 | central public organisation | 36000 | [NAME]
 |  |  |  |  |  |  |  |  | [NAME] | department2 | department3 | [NAME] | [NAME]
 | [NAME] | department2 | department3 |  | [NAME] | [NAME] | category1 | 2018 |  | 0 | 11672.00312989045 | 3434.425835475578 | 0
2018 |  |  |  |  |  |  |  | 2019 | 36733.57664233576 | 0 | 11703.98122065728 | 3763.47262210797 | 0
2019 |  |  |  |  |  |  |  | 2020 | 6122.262773722628 | 0 | 7770.676056338029 | 802.0515424164524 | 0
2020 |  |  |  |  |  |  |  | 2021 | 0 | 0 | 0 | 0 | 0
2021 |  |  |  |  |  |  |  | 2022 | 0 | 0 | 0 | 0 | 0
2022 |  |  |  |  |  |  |  | 2023 | 0 | 0 | 0 | 0 | 0
2023
 |  |  |  |  |  |  | category2 | 2018 | 36633.21167883211 | 0 | 11672.00312989045 | 3434.425835475578 | 0
 |  |  |  |  |  |  |  | 2019 | 36733.57664233576 | 0 | 11703.98122065728 | 3763.47262210797 | 0
 |  |  |  |  |  |  |  | 2020 | 6122.262773722628 | 0 | 7770.676056338029 | 802.0515424164524 | 0
 |  |  |  |  |  |  |  | 2021 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 2022 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 2023 | 0 | 0 | 0 | 0 | 0