I have the spreadsheet above, that describes a job's Income, outcome, and profit. It also shows if an employee took place in that job or not, in order to calculate his income. In the demo above, for the 1st job employees A,B,C will share 70$, and for the 2nd job A and C will share 140$. That means (for the second table) that A = 70/3 +14/2 = 93.3, b = 70/3 + 0 = 23.3 etc.
So if someone has taken part in a job, i have to choose the appropriate box, to calculate his income.
The question is what should i do, in order to auto calculate the employees income, when his checkbox is null or not for every job.
(Checkboxes are activeX control checkboxes and in each row there are grouped)