Practical solution using sumproduct in MS Excel

Welcome to the!
I enter the date and name of employees in an Excel worksheet. In another column I enter whether an employee came on the scheduled time with a blank or ‘no’ when she was late. Our company monitors attendance violations every month (30 days) and if an employee is late on 3 days in a month he is ‘counseled’.
I would like to automate my Excel worksheet in such a way that if there are 3 cells in the third column (attendance violaton) that are not blank in…

Leave a Reply

Your email address will not be published. Required fields are marked *