Spreadsheet: 865204d1712243455-sumifs-with-index-and-match-pensionable-pt-hours
Sheet: ExcelForum

Payment Date | PThours1 | PThours2 | PThours3 | Expenditure Code1 | Expenditure Code2 | Expenditure Code3 |  |  | Expenditure codes | Pensionable
2009-01-09 00:00:00 | 32 | 7.5 | 0 | 48579 | 48110 | 48577 |  |  | 20030 | No
2009-02-13 00:00:00 | 54.5 | 7.5 | 0 | 48579 | 48577 | 48577 |  |  | 39300 | No
2009-03-13 00:00:00 | 33.5 | 5 | 0 | 48577 | 46028 | 48110 |  |  | 44744 | No
2009-04-09 00:00:00 | 42 | 12 | 0 | 46028 | 48577 | 48110 |  |  | 45994 | Yes
2009-05-08 00:00:00 | 3 | 5 | 0 | 45994 | 48110 | 46533 |  |  | 46028 | Yes
2009-06-12 00:00:00 | 17 | 105.75 | 0 | 45994 | 48577 | 48577 |  |  | 46500 | Yes
2009-07-10 00:00:00 | 21.25 | 0 | 0 | 48577 | 46533 | 0 |  |  | 46511 | No
2009-08-14 00:00:00 | 44 | 6 | 0 | 48577 | 48552 | 46533 |  |  | 46514 | No
2009-10-09 00:00:00 | 25 | 1.5 | 2.5 | 45994 | 48110 | 46533 |  |  | 46531 | No
2009-12-14 00:00:00 | 56.5 | 10 | 0 | 48577 | 48110 | 48577 |  |  | 46532 | No
2010-01-08 00:00:00 | 16.5 | 41.5 | 7.5 | 48577 | 48577 | 45994 |  |  | 46533 | No
2010-02-12 00:00:00 | 13 | 2.5 | 0 | 48577 | 48110 | 0 |  |  | 46900 | No
2010-03-12 00:00:00 | 2 | 0 | 0 | 39300 | 0 | 0 |  |  | 48110 | Yes
2010-04-14 00:00:00 | 23 | 12.5 | 0 | 48577 | 48572 | 45994 |  |  | 48572 | Yes
2010-05-14 00:00:00 | 17 | 14 | 9.5 | 48577 | 48576 | 48572 |  |  | 48577 | Yes
2010-06-18 00:00:00 | 33 | 16.5 | 2.5 | 48577 | 48572 | 48110 |  |  | 48579 | Yes
2010-07-09 00:00:00 | 20 | 10 | 23.5 | 48577 | 48579 | 48577
2010-08-13 00:00:00 | 15 | 0 | 0 | 48577 | 0 | 0
2010-09-10 00:00:00 | 32 | 0 | 0 | 48577 | 0 | 0 |  |  | Start date | End date | PThours1 | PThours2 | PThours3 | PThours1 if code in column E is pensionable | PThours1 if code in column F is pensionable | PThours1 if code in column G is pensionable
2010-10-08 00:00:00 | 46 | 0 | 0 | 45994 | 48577 | 46900 |  |  | 2009-09-01 00:00:00 | 2010-08-31 00:00:00
2010-11-12 00:00:00 | 59 | 18 | 0 | 45994 | 48577 | 48110 |  |  | 2010-09-01 00:00:00 | 2011-08-31 00:00:00 | 208 | 202.5 | 69.75 | 174 | 127.5 | 15.25
2010-12-13 00:00:00 | 15 | 47 | 0 | 48110 | 47032 | 48577 |  |  | 2011-09-01 00:00:00 | 2012-08-31 00:00:00 | 104 | 8.5 | 0 | 104 | 5.5 | 0
2011-01-14 00:00:00 | 34 | 4 | 9 | 46900 | 48577 | 48110 |  |  | 2012-09-01 00:00:00 | 2013-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2011-02-11 00:00:00 | 9 | 47 | 6.25 | 48110 | 45994 | 48577 |  |  | 2013-09-01 00:00:00 | 2014-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2011-03-11 00:00:00 | 2 | 11.5 | 0 | 48110 | 48577 | 47032 |  |  | 2014-09-01 00:00:00 | 2015-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2011-04-08 00:00:00 | 1 | 24.5 | 0 | 48110 | 48577 | 46500 |  |  | 2015-09-01 00:00:00 | 2016-08-31 00:00:00 | 125 | 0 | 0 | 75 | 0 | 0
2011-05-13 00:00:00 | 1 | 20.5 | 0 | 48110 | 48577 | 47032 |  |  | 2016-09-01 00:00:00 | 2017-08-31 00:00:00 | 30.5 | 0 | 0 | 12.5 | 0 | 0
2011-06-17 00:00:00 | 2 | 2 | 54.5 | 48110 | 48577 | 0 |  |  | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2011-07-08 00:00:00 | 7 | 28 | 0 | 48577 | 0 | 0 |  |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2011-11-11 00:00:00 | 32 | 0 | 0 | 48577 | 0 | 0 |  |  | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2011-12-09 00:00:00 | 20 | 0 | 0 | 48577 | 0 | 0 |  |  | 2020-09-01 00:00:00 | 2021-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-13 00:00:00 | 27 | 0 | 0 | 48577 | 0 | 0
2012-02-10 00:00:00 | 15 | 3 | 0 | 48577 | 0 | 0
2012-03-09 00:00:00 | 10 | 5.5 | 0 | 48577 | 48579 | 0
2015-11-12 00:00:00 | 10 | 0 | 0 | 46500 | 0 | 0
2015-12-10 00:00:00 | 8 | 0 | 0 | 46500 | 0 | 0
2016-01-14 00:00:00 | 4 | 0 | 0 | 46500 | 0 | 0
2016-02-11 00:00:00 | 9 | 0 | 0 | 48572 | 0 | 0
2016-03-10 00:00:00 | 25.5 | 0 | 0 | 48577 | 20030 | 0
2016-04-14 00:00:00 | 12 | 0 | 0 | 44744 | 48572 | 0
2016-05-12 00:00:00 | 18.5 | 0 | 0 | 48572 | 44744 | 0
2016-06-09 00:00:00 | 18 | 0 | 0 | 44744 | 48572 | 0
2016-07-14 00:00:00 | 14 | 0 | 0 | 44744 | 48572 | 0
2016-08-11 00:00:00 | 6 | 0 | 0 | 44744 | 48572 | 0
2016-10-13 00:00:00 | 8.5 | 0 | 0 | 46500 | 0 | 0
2016-11-10 00:00:00 | 4 | 0 | 0 | 46500 | 0 | 0
2016-12-08 00:00:00 | 18 | 0 | 0 | 44744 | 20030 | 0