My payroll spread sheet utilizes a drop down list for employee names to be added to a work day. I use Vlookup to add the employees pay rate next to their name from my employee list on another sheet. I have tried using SumIF to add up all the pay days but it will not work. Maybe its because the criteria Im trying to use (e.g, Employee name) is coming from a drop down list? How can I make this work and keep my employee drop down list? Ideally I would like the employee drop down list to add the employee name, employee number and pay rate all in seperate cells. I could not acheive that nor could I get total pay for each employee over a pay week. Excel 2013

By: Robert Chupick

One thought on “Payroll

Leave a Reply

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