If a cell in column C-N has a text "A,K,D,P" then the value is 0.5, if all 12 cells have specific text the value in column O must be 6. I don't understand the formula inserted in column O and everytime I copy the formula it doesn't apply the needed value. Please view my file and explain.

Attached Files

payroll sample.xlsx (32.2 KB, 8 views)