Spreadsheet: 453538d1459353891-sum-data-when-considering-several-variables-example-sumproduct-and-sumif
Sheet: Staff Data

NOTATION | Area | No. | Full Name | FTE | HC | GRADE | ROLE DESCRIPTION | Start Date | End Date | Salaries |  | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00
 | GHI |  |  | 0.6 | 1 | Director |  | 2014-01-01 00:00:00 | 2099-12-31 00:00:00 | 15000
 | EXEC |  |  | 1 | 1 | Director |  | 2008-05-01 00:00:00 | 2099-12-31 00:00:00 | 15000
 | EXEC |  |  | 1 | 1 | Director |  | 2010-02-01 00:00:00 | 2099-12-31 00:00:00 | 15000
 | ABC |  |  | 1 | 1 | Director |  | 2016-05-01 00:00:00 | 2099-12-31 00:00:00 | 15000
 | ABC |  |  | 1 | 1 | Employee |  | 2012-08-20 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2011-10-24 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2014-12-08 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2011-10-24 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2014-06-02 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2014-06-02 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2015-02-09 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2015-03-04 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2014-10-20 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2011-10-03 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2015-01-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC |  |  | 1 | 1 | Employee |  | 2014-03-06 00:00:00 | 2099-12-31 00:00:00 | 22000
 | DEF |  |  | 0.42857143 | 1 | Employee |  | 2015-02-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | DEF |  |  | 1 | 1 | Employee |  | 2016-04-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | DEF |  |  | 0.4 | 1 | Employee |  | 2016-04-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | DEF |  |  | 0.2 | 1 | Employee |  | 2016-04-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC Casual |  |  | 1 | 1 | Employee |  | 2011-01-13 00:00:00 | 2099-12-31 00:00:00 | 22000
 | TA STAFF |  |  | 1 | 1 | Employee |  | 2013-07-08 00:00:00 | 2099-12-31 00:00:00 | 22000
 | TA STAFF |  |  | 1 | 1 | Employee |  | 2015-04-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | TA STAFF |  |  | 1 | 1 | Employee |  | 2015-04-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | TA STAFF |  |  | 1 | 1 | Employee |  | 2013-06-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | TA STAFF |  |  | 1 | 1 | Employee |  | 2015-03-16 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC Casual |  |  | 0.2 | 1 | Employee |  | 2014-06-25 00:00:00 | 2099-12-31 00:00:00 | 22000
 | ABC Casual |  |  | 0.2 | 1 | Employee |  | 2014-03-03 00:00:00 | 2099-12-31 00:00:00 | 22000
 | GTS |  |  | 0.2 | 1 | Employee |  | 2016-04-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | GTS |  |  | 0.2 | 1 | Employee |  | 2016-04-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | GTS |  |  | 0.2 | 1 | Employee |  | 2016-04-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | GTS |  |  | 0.2 | 1 | Employee |  | 2016-04-01 00:00:00 | 2099-12-31 00:00:00 | 22000
 | MARK |  |  | 1 | 1 | Manager |  | 2015-01-01 00:00:00 | 2099-12-31 00:00:00 | 60000
 | EXEC |  |  | 0.6 | 1 | Non-Exec Director |  | 2015-04-01 00:00:00 | 2099-12-31 00:00:00 | 12000
 | GHI |  |  | 1 | 1 | Senior Employee |  | 2016-04-01 00:00:00 | 2099-12-31 00:00:00 | 6000
 | GHI |  |  | 1 | 1 | Senior Employee |  | 2016-04-01 00:00:00 | 2099-12-31 00:00:00 | 6000
 | ABC |  |  | 1 | 1 | Senior Employee |  | 2016-01-11 00:00:00 | 2099-12-31 00:00:00 | 6000
 | ABC |  |  | 1 | 1 | Senior Employee |  | 2009-03-02 00:00:00 | 2099-12-31 00:00:00 | 6000
 | TA STAFF |  |  | 1.14285714 | 1 | Senior Employee |  | 2015-06-01 00:00:00 | 2099-12-31 00:00:00 | 6000
 | TA STAFF |  |  | 1 | 1 | Senior Employee |  | 2016-02-01 00:00:00 | 2099-12-31 00:00:00 | 6000
 | ABC |  |  | 1 | 1 | Senior Manager |  | 2011-12-07 00:00:00 | 2099-12-31 00:00:00 | 8000
 | ABC |  |  | 1 | 1 | Senior Manager |  | 2009-03-02 00:00:00 | 2099-12-31 00:00:00 | 8000
 |  |  | NI |  | 0.065
 |  |  | Employee | 0.02
 |  |  | Senior Employee | 0.05
 |  |  | Manager | 0.06
 |  |  | Senior Manager | 0.07
 |  |  | Director | 0.08
 |  |  | Non-Exec Director | 0