Function/Formula that will exclude a worker on a day.

[bjayetnap]

Good day experts! I have an excel problem that I need help with.

Case:

I have four workers that work from Monday to Sunday, but sometimes not all of them are present on a day. There are times only two works, sometimes 3, etc.

Let's take a look at Monday Sheet, E8. That is the total quantity of the product with a rate of 0.7 per piece. It needs to be divided to my workers from B10 to B13 with a 0.7 rate per piece (E8 * 0.7 / 4*). *My problem now is, what if M1 is absent on Monday? Now I need to divide E8 into three workers instead of 4. I'm thinking of a checkbox or any besides A10 to A13 that will disable that worker's cell so they are not included on that day, and E8 will now be divided depending on who works on that day.

Any help or guide is appreciated.

[Glenn Kennedy]

Where do you record the number of workers that are present on each day?

[bjayetnap]

We record the attendance of workers manually—a notebook. My business is not computerized. I only created an excel to compute their salary faster.

[Glenn Kennedy]

Yes. fine. But Excel needs to know what the denominator is going to be??!! Look at Monday, for example. How will Excel KNOW whether to divide by 1, or 2, or 3, or 4???

[bjayetnap]

I don't know if I did it right. I added remarks on A11 to A14 using data validation. An updated worksheet is attached.

[Glenn Kennedy]

Perfect. Use this:

=IF(A11="A",0,$E$8*0.7/(COUNTIF($A$11:$A$14,"P")))

copied down.

[bjayetnap]

Perfect. Use this:

=IF(A11="A",0,$E$8*0.7/(COUNTIF($A$11:$A$14,"P")))

copied down.

Thank you!

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.