Problem description:
I have a production process consisting of 14 stages/steps (columns A to N).
I have six employees (cells A2 to A7, each employee is a number - 4, 5, 6, 14, 18 and 23).
I need a formula that reads cells A2-N2 and, if the number of employees involved in the production process is greater than 1, the result must be 0 (zero). If the number of employees involved in the production is 1 (regardless of the number of production stages in which this employee was involved) then the result must equal to the employee number.
Thank you in advance for your help with this formula.
Bookmarks