Guest User

Untitled

a guest
Apr 21st, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. {=SUM(INDEX(ShiftValueT[[Value]:[Value]],
  2. MATCH(INDEX(Record[[UniqueShift]:[UniqueShift]],
  3. MATCH(B$1&FALSE()&$A2,
  4. Record[[Year]:[Year]]&Record[[ISERROR]:[ISERROR]]&Record[[Medic]:[Medic]],0)),
  5. ShiftValueT[[UniqueShift]:[UniqueShift]],0)))}
Add Comment
Please, Sign In to add comment