Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {=SUM(INDEX(ShiftValueT[[Value]:[Value]],
- MATCH(INDEX(Record[[UniqueShift]:[UniqueShift]],
- MATCH(B$1&FALSE()&$A2,
- Record[[Year]:[Year]]&Record[[ISERROR]:[ISERROR]]&Record[[Medic]:[Medic]],0)),
- ShiftValueT[[UniqueShift]:[UniqueShift]],0)))}
Add Comment
Please, Sign In to add comment