Spreadsheet: 731548d1620402141-sumif-with-additional-criteria-example
Sheet: NLR7

Document Date | Comments | Document Number | Amount | Nominal Code | Period | Type | NL
2020-04-29 00:00:00 | FURLOUGH INCOME | GJ0005458 | -6530.62 | 5364 - COS - ED Admin Team | 1 , APR20 | Nominal Journal
2020-04-01 00:00:00 | REVERSE OF GJ0005427 FURLOUGH MAR20 | GJ0005428 | 1499.48 | 5364 - COS - ED Admin Team | 1 , APR20 | Nominal Journal
2020-04-30 00:00:00 | Salaries | GJ0005467 | 5889.7 | 5364 - COS - ED Admin Team | 1 , APR20 | Nominal Journal
2020-05-31 00:00:00 | furlough income may20 | GJ0005672 | -4378.83 | 5364 - COS - ED Admin Team | 2 , MAY20 | Nominal Journal
2020-05-31 00:00:00 | Salaries | GJ0005658 | 6081.46 | 5364 - COS - ED Admin Team | 2 , MAY20 | Nominal Journal
2020-06-02 00:00:00 | CB0017380 FURLOUGH | GJ0005954 | -4378.83 | 5364 - COS - ED Admin Team | 3 , JUN20 | Nominal Journal
2020-06-30 00:00:00 | FURLOUGH JUN20 | GJ0006016 | -2863.48 | 5364 - COS - ED Admin Team | 3 , JUN20 | Nominal Journal
2020-06-01 00:00:00 | REVERSE OF GJ0005672 furlough income may20 | GJ0005673 | 4378.83 | 5364 - COS - ED Admin Team | 3 , JUN20 | Nominal Journal
2020-06-30 00:00:00 | Salaries | GJ0005839 | 6515.09 | 5364 - COS - ED Admin Team | 3 , JUN20 | Nominal Journal
2020-07-02 00:00:00 | gj0006074 correction | GJ0006097 | -5726.95 | 5364 - COS - ED Admin Team | 4 , JUL20 | Nominal Journal
2020-07-01 00:00:00 | REVERSE OF GJ0006016 FURLOUGH JUN20 | GJ0006017 | 2863.48 | 5364 - COS - ED Admin Team | 4 , JUL20 | Nominal Journal
2020-07-31 00:00:00 | Salaries | GJ0006052 | 7083.25 | 5364 - COS - ED Admin Team | 4 , JUL20 | Nominal Journal
2020-07-02 00:00:00 | FURLOUGH INCOME JUN20 | GJ0006074 | 2863.48 | 5364 - COS - ED Admin Team | 4 , JUL20 | Nominal Journal
2020-08-31 00:00:00 | Salaries - Aug20 | GJ0006253 | 5985.18 | 5364 - COS - ED Admin Team | 5 , AUG20 | Nominal Journal
2020-09-30 00:00:00 | Salaries - Sep20 | GJ0006444 | 5700.65 | 5364 - COS - ED Admin Team | 6 , SEP20 | Nominal Journal
2020-10-31 00:00:00 | Salaries - Oct20 | GJ0006661 | 5477.1 | 5364 - COS - ED Admin Team | 7 , OCT20 | Nominal Journal
2020-04-29 00:00:00 | FURLOUGH INCOME | GJ0005458 | -187.29 | 5367 - Engineered Delivery Pension | 1 , APR20 | Nominal Journal
2020-04-01 00:00:00 | REVERSE OF GJ0005427 FURLOUGH MAR20 | GJ0005428 | 30.17 | 5367 - Engineered Delivery Pension | 1 , APR20 | Nominal Journal
2020-04-30 00:00:00 | Salaries | GJ0005467 | 194.05 | 5367 - Engineered Delivery Pension | 1 , APR20 | Nominal Journal
2020-05-31 00:00:00 | furlough income may20 | GJ0005672 | -136.46 | 5367 - Engineered Delivery Pension | 2 , MAY20 | Nominal Journal
2020-05-31 00:00:00 | Salaries | GJ0005658 | 203.26 | 5367 - Engineered Delivery Pension | 2 , MAY20 | Nominal Journal
2020-06-02 00:00:00 | CB0017380 FURLOUGH | GJ0005954 | -136.46 | 5367 - Engineered Delivery Pension | 3 , JUN20 | Nominal Journal
2020-06-30 00:00:00 | FURLOUGH JUN20 | GJ0006016 | -99.01 | 5367 - Engineered Delivery Pension | 3 , JUN20 | Nominal Journal
2020-06-01 00:00:00 | REVERSE OF GJ0005672 furlough income may20 | GJ0005673 | 136.46 | 5367 - Engineered Delivery Pension | 3 , JUN20 | Nominal Journal
2020-06-30 00:00:00 | Salaries | GJ0005839 | 241.02 | 5367 - Engineered Delivery Pension | 3 , JUN20 | Nominal Journal
2020-07-02 00:00:00 | gj0006074 correction | GJ0006097 | -198.02 | 5367 - Engineered Delivery Pension | 4 , JUL20 | Nominal Journal
2020-07-01 00:00:00 | REVERSE OF GJ0006016 FURLOUGH JUN20 | GJ0006017 | 99.01 | 5367 - Engineered Delivery Pension | 4 , JUL20 | Nominal Journal
2020-07-31 00:00:00 | Salaries | GJ0006052 | 299.45 | 5367 - Engineered Delivery Pension | 4 , JUL20 | Nominal Journal
2020-07-02 00:00:00 | FURLOUGH INCOME JUN20 | GJ0006074 | 99.01 | 5367 - Engineered Delivery Pension | 4 , JUL20 | Nominal Journal
2020-08-31 00:00:00 | Salaries - Aug20 | GJ0006253 | 410.96 | 5367 - Engineered Delivery Pension | 5 , AUG20 | Nominal Journal
2020-09-30 00:00:00 | Salaries - Sep20 | GJ0006444 | 375.31 | 5367 - Engineered Delivery Pension | 6 , SEP20 | Nominal Journal
2020-10-31 00:00:00 | Salaries - Oct20 | GJ0006661 | 368.93 | 5367 - Engineered Delivery Pension | 7 , OCT20 | Nominal Journal
2020-04-29 00:00:00 | FURLOUGH INCOME | GJ0005458 | -137.04 | 5368 - ED Admin Team Pension | 1 , APR20 | Nominal Journal
2020-04-01 00:00:00 | REVERSE OF GJ0005427 FURLOUGH MAR20 | GJ0005428 | 25.24 | 5368 - ED Admin Team Pension | 1 , APR20 | Nominal Journal
2020-04-30 00:00:00 | Salaries | GJ0005467 | 102.01 | 5368 - ED Admin Team Pension | 1 , APR20 | Nominal Journal
2020-05-31 00:00:00 | furlough income may20 | GJ0005672 | -95.75 | 5368 - ED Admin Team Pension | 2 , MAY20 | Nominal Journal
2020-05-31 00:00:00 | Salaries | GJ0005658 | 106.9 | 5368 - ED Admin Team Pension | 2 , MAY20 | Nominal Journal
2020-06-02 00:00:00 | CB0017380 FURLOUGH | GJ0005954 | -95.75 | 5368 - ED Admin Team Pension | 3 , JUN20 | Nominal Journal
2020-06-30 00:00:00 | FURLOUGH JUN20 | GJ0006016 | -123.12 | 5368 - ED Admin Team Pension | 3 , JUN20 | Nominal Journal
2020-06-01 00:00:00 | REVERSE OF GJ0005672 furlough income may20 | GJ0005673 | 95.75 | 5368 - ED Admin Team Pension | 3 , JUN20 | Nominal Journal
2020-06-30 00:00:00 | Salaries | GJ0005839 | 118.27 | 5368 - ED Admin Team Pension | 3 , JUN20 | Nominal Journal
2020-07-02 00:00:00 | gj0006074 correction | GJ0006097 | -246.24 | 5368 - ED Admin Team Pension | 4 , JUL20 | Nominal Journal
2020-07-01 00:00:00 | REVERSE OF GJ0006016 FURLOUGH JUN20 | GJ0006017 | 123.12 | 5368 - ED Admin Team Pension | 4 , JUL20 | Nominal Journal
2020-07-31 00:00:00 | Salaries | GJ0006052 | 133.26 | 5368 - ED Admin Team Pension | 4 , JUL20 | Nominal Journal
2020-07-02 00:00:00 | FURLOUGH INCOME JUN20 | GJ0006074 | 123.12 | 5368 - ED Admin Team Pension | 4 , JUL20 | Nominal Journal
2020-08-31 00:00:00 | Salaries - Aug20 | GJ0006253 | 103.38 | 5368 - ED Admin Team Pension | 5 , AUG20 | Nominal Journal
2020-09-30 00:00:00 | Salaries - Sep20 | GJ0006444 | 110.62 | 5368 - ED Admin Team Pension | 6 , SEP20 | Nominal Journal
2020-10-31 00:00:00 | Salaries - Oct20 | GJ0006661 | 103.92 | 5368 - ED Admin Team Pension | 7 , OCT20 | Nominal Journal