Hi guys, can anyone give me some help?
I have a file attached for you to check it.
There is a tab called WSIB in there. The column FROM JAN CONTRACTORS is getting values from the CP 06 Jan and CP 20 Jan. When the name of the employee is inputted in the name cell, it will look using the index/match formula for the same name in both of these tabs.
What I want is this:
- In the CP tabs, there is a column called "Include in the WSIB?" that offer to the user the choice of including that data of the employee in the Summary WSIB tab ; (I did it)
- In the FROM JAN CONTRACTORS it will sum both the data from the CP tabs of the month ; (I did it)
But what is happening is that it will only sum when the name of the employee is in BOTH of the CP tabs... I Want to have partial sums (if only one CP tab has the name of the employee it will give the partial sum).
Can you guys help me on that?
Thank You,
Daniel Grossi
Bookmarks