Hi all,
I have a bunch of information which I need to extract specific information per employee.
There are only 5 different salary sacrific companies at the moment (potential to change like the employees who are participating.)
I have tried a sumproduct and sumifs formulas but can't get either of them to work currently.
1st tab is the table of employees, their sal sac company and work code.
Second tab is the detail information - I have deleted most of the rows and columns and just left the sal sac columns (so the column numbers change all the time, same as the row numbers).
To make things a little more complex most of guys work on multiple projects in 1 month - however their sal sac alwasy goes to one of the numbers shown.
What formula will work so that I can extra the value of their sal sac based on sal sac company (B), employee code (A) and employee (C).
Ta.
Bookmarks