Spreadsheet: 762800d1641828412-sumifs-criteria-matching-between-tables-help
Sheet: Dashboard

 |  | Sum of Reqd FTE | Column Labels |  |  |  | Available FTE
 |  | Row Labels | JAN | FEB | MAR |  | Row Labels | Sum of JAN | Sum of FEB | Sum of MAR
 |  | [NAME] |  |  |  |  | [NAME]
 |  | Fisherman | 0.1 | 0.2 | 0.2 |  | Fisherman | 0.1 | 0.1 | 0.1
 |  | [NAME] | 0.1 | 0.2 | 0.2 |  | [NAME] | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  | [NAME]
 |  | Painter | 0.3 | 0.25 | 0.25 |  | Painter | 0.6 | 0.6 | 0.6
 |  | Arthur Jones Total | 0.3 | 0.25 | 0.25 |  | Arthur Jones Total | 0.6 | 0.6 | 0.6
 |  | Nobody Inparticular |  |  |  |  | Nobody Inparticular | 0.1 | 0.1 | 0.1
 |  | Bagging | 0.02 | 0.1 | 0.1 |  | [NAME]
 |  | Nobody Inparticular Total | 0.02 | 0.1 | 0.1 |  | Bagging | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  | [NAME] Total | 0.1 | 0.1 | 0.1
 |  | Bagging | 0.2 | 0.2 | 0.2 |  | [NAME]
 |  | [NAME] Total | 0.2 | 0.2 | 0.2 |  | Manager | 0.45 | 0.45 | 0.45
 |  | [NAME] |  |  |  |  | Window [NAME] | 0.45 | 0.45 | 0.45
 |  | Window [NAME] | 0.23 | 0.28 | 0.23 |  | Deputy Manager | 0 | 0 | 0
 |  | [NAME] | 0.23 | 0.28 | 0.23 |  | [NAME] | 0.9 | 0.9 | 0.9
 |  | [NAME] |  |  |  |  | [NAME]
 |  | Bagging | 0.2 | 0.2 | 0.2 |  | Fisherman | 0.1 | 0.1 | 0.1
 |  | [NAME] Total | 0.2 | 0.2 | 0.2 |  | [NAME] Total | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  | [NAME]
 |  | Sales | 0.05 | 0.05 | 0.05 |  | Painter | 0.1 | 0.1 | 0.1
 |  | [NAME] | 0.05 | 0.05 | 0.05 |  | [NAME] | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  | [NAME]
 |  | laundry | 0.1 | 0.1 |  |  | Manager | 0.45 | 0.45 | 0.45
 |  | [NAME] | 0.1 | 0.1 |  |  | Deputy Manager | 0.45 | 0.45 | 0.45
 |  | [NAME] |  |  |  |  | [NAME] | 0.9 | 0.9 | 0.9
 |  | Horse Doctor | 0.48 | 0.38 | 0.38 |  | [NAME]
 |  | [NAME] | 0.48 | 0.38 | 0.38 |  | Bagging | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  | [NAME] Total | 0.1 | 0.1 | 0.1
 |  | Manager | 1 | 1.1 | 1.2 |  | [NAME]
 |  | [NAME] Total | 1 | 1.1 | 1.2 |  | Sales | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  | [NAME] | 0.1 | 0.1 | 0.1
 |  | Grass | 0.15 | 0.25 | 0.2 |  | [NAME]
 |  | [NAME] | 0.15 | 0.25 | 0.2 |  | laundry | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  | [NAME] | 0.1 | 0.1 | 0.1
 |  | Gladiator | 0.85 | 0.9500000000000001 | 0.9500000000000001 |  | [NAME]
 |  | [NAME] | 0.85 | 0.9500000000000001 | 0.9500000000000001 |  | Manager | 0.45 | 0.45 | 0.45
 |  | [NAME] |  |  |  |  | Deputy Manager | 0 | 0 | 0
 |  | Decorator | 0.05 | 0.05 |  |  | Horse Doctor | 0.45 | 0.45 | 0.45
 |  | [NAME] | 0.05 | 0.05 |  |  | [NAME] | 0.9 | 0.9 | 0.9
 |  | Lotus [NAME] |  |  |  |  | [NAME]
 |  | Deputy Manager | 0.5 | 0.5 | 0.5 |  | Manager | 0.9 | 0.9 | 0.9
 |  | Lotus Blossom Total | 0.5 | 0.5 | 0.5 |  | Deputy Manager | 0 | 0 | 0
 |  | [NAME] |  |  |  |  | [NAME] Total | 0.9 | 0.9 | 0.9
 |  | Fisherman | 0.1 | 0.1 | 0.1 |  | [NAME]
 |  | [NAME] | 0.1 | 0.1 | 0.1 |  | Grass | 0.05 | 0.05 | 0.05
 |  | [NAME] |  |  |  |  | [NAME] | 0.05 | 0.05 | 0.05
 |  | Files | 0.32 | 0.32 | 0.22 |  | [NAME]
 |  | Philleas Fogg Total | 0.32 | 0.32 | 0.22 |  | Gladiator | 0.9 | 0.9 | 0.9
 |  | [NAME] |  |  |  |  | [NAME] | 0.9 | 0.9 | 0.9
 |  | Gladiator | 0.2 | 0.2 | 0.1 |  | [NAME]
 |  | Mick Jagger Total | 0.2 | 0.2 | 0.1 |  | Decorator | 0.3 | 0.3 | 0.3
 |  | [NAME] |  |  |  |  | [NAME] | 0.3 | 0.3 | 0.3
 |  | Manager | 0.2 |  |  |  | Lotus [NAME]
 |  | [NAME] | 0.2 |  |  |  | Manager | 0 | 0 | 0
 |  | Horace Rumpole |  |  |  |  | Deputy Manager | 0.9 | 0.9 | 0.9
 |  | Manager | 0.6000000000000001 | 0.6000000000000001 | 0.6000000000000001 |  | Lotus Blossom Total | 0.9 | 0.9 | 0.9
 |  | Deputy Manager | 0.02 | 0.2 | 0.2 |  | [NAME]
 |  | Horace Rumpole Total | 0.6200000000000001 | 0.8 | 0.8 |  | Fisherman | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  | [NAME] | 0.1 | 0.1 | 0.1
 |  | Decorator | 0.2 | 0.2 | 0.2 |  | [NAME]
 |  | [NAME] Total | 0.2 | 0.2 | 0.2 |  | Files | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  | Philleas Fogg Total | 0.1 | 0.1 | 0.1
 |  | Fisherman | 0.3 | 0.2 | 0.2 |  | [NAME]
 |  | [NAME] | 0.3 | 0.2 | 0.2 |  | Gladiator | 0.3 | 0.3 | 0.3
 |  | [NAME] |  |  |  |  | Mick Jagger Total | 0.3 | 0.3 | 0.3
 |  | Manager | 0.6 | 0.6 | 0.6 |  | [NAME]
 |  | Deputy Manager | 0.45 | 0.45 | 0.45 |  | Manager | 0.45 | 0 | 0
 |  | [NAME] | 1.05 | 1.05 | 1.05 |  | Deputy Manager | 0.45 | 0 | 0
 |  | Emile Dunbar |  |  |  |  | [NAME] | 0.9 | 0 | 0
 |  | Decorator | 0.15 | 0.25 | 0.25 |  | Isla Skye
 |  | Emile Dunbar  Total | 0.15 | 0.25 | 0.25 |  | Bagging | 0.1 | 0.1 | 0.1
 |  | Ford Prefect |  |  |  |  | Isla Skye Total | 0.1 | 0.1 | 0.1
 |  | Buyer | 0.1 | 0.1 | 0.1 |  | Horace Rumpole
 |  | Ford Prefect Total | 0.1 | 0.1 | 0.1 |  | Manager | 0.8 | 0.7 | 0.7
 |  | Fred Davies |  |  |  |  | Deputy Manager | 0.1 | 0.2 | 0.2
 |  | Manager | 0.4 | 0.4 | 0.4 |  | Horace Rumpole Total | 0.9 | 0.8999999999999999 | 0.8999999999999999
 |  | Fred Davies Total | 0.4 | 0.4 | 0.4 |  | [NAME]
 |  | Captain [NAME] |  |  |  |  | Decorator | 0.3 | 0.3 | 0.3
 |  | Sales | 0.42 | 0.6200000000000001 | 0.42 |  | [NAME] Total | 0.3 | 0.3 | 0.3
 |  | Captain [NAME] | 0.42 | 0.6200000000000001 | 0.42 |  | [NAME]
 |  | Grand Total | 8.290000000000001 | 8.850000000000001 | 8.299999999999999 |  | Fisherman | 0.1 | 0.1 | 0.1
 |  |  |  |  |  |  | [NAME] | 0.1 | 0.1 | 0.1
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Manager | 0.45 | 0.45 | 0.45
 |  |  |  |  |  |  | Deputy Manager | 0.45 | 0.45 | 0.45
 |  |  |  |  |  |  | [NAME] | 0.9 | 0.9 | 0.9
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Manager | 0.45 | 0.45 | 0.45
 |  |  |  |  |  |  | Deputy Manager | 0.45 | 0.45 | 0.45
 |  |  |  |  |  |  | [NAME] | 0.9 | 0.9 | 0.9
 |  |  |  |  |  |  | Emile Dunbar
 |  |  |  |  |  |  | Decorator | 0.3 | 0.3 | 0.3
 |  |  |  |  |  |  | Emile Dunbar  Total | 0.3 | 0.3 | 0.3
 |  |  |  |  |  |  | Ford Prefect
 |  |  |  |  |  |  | Buyer | 0.3 | 0.3 | 0.3
 |  |  |  |  |  |  | Ford Prefect Total | 0.3 | 0.3 | 0.3
 |  |  |  |  |  |  | TBC
 |  |  |  |  |  |  | Gladiator | 0.9 | 0.9 | 0.9
 |  |  |  |  |  |  | TBC Total | 0.9 | 0.9 | 0.9
 |  |  |  |  |  |  | Fred Davies
 |  |  |  |  |  |  | Manager | 0.4 | 0.4 | 0.4
 |  |  |  |  |  |  | Deputy Manager | 0 | 0 | 0
 |  |  |  |  |  |  | Fred Davies Total | 0.4 | 0.4 | 0.4
 |  |  |  |  |  |  | Captain [NAME]
 |  |  |  |  |  |  | Sales | 0.1 | 0.1 | 0.1
 |  |  |  |  |  |  | Captain [NAME] | 0.1 | 0.1 | 0.1
 |  |  |  |  |  |  | Grand Total | 13.75 | 12.85 | 12.85