Home

Employee availability formula

%3CLINGO-SUB%20id%3D%22lingo-sub-712236%22%20slang%3D%22en-US%22%3EEmployee%20availability%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712236%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20use%20an%20excel%20table%20to%20calculate%20employees%20that%20are%20already%20scheduled%20in%20a%20column%2C%20so%20that%20at%20the%20bottom%20I%20have%20a%20list%20of%20what%20employee%20resources%20are%20still%20available%20to%20be%20assigned.%3CBR%20%2F%3ESo%20I%20have%20a%20very%20simple%20single%20sheet%20table%20with%20jobs%20sites%20in%20column%20A%2C%20rows%201-20%20being%20a%20different%20site.%20Employees%20are%20in%20column%20B%20and%20assigned%20to%20jobs%20by%20row%20(b1-b20).%3CBR%20%2F%3EHow%20can%20I%20assign%20a%20value%20to%20the%20employee%20names%20to%20get%20a%20running%20total%20at%20the%20bottom%20of%20employees%20that%20are%20available%20to%20put%20on%20jobs.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-712236%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-713864%22%20slang%3D%22en-US%22%3ERe%3A%20Employee%20availability%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-713864%22%20slang%3D%22en-US%22%3EPlease%20attach%20your%20sample%20file%20with%20manually%20entered%20results.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-713941%22%20slang%3D%22en-US%22%3ERe%3A%20Employee%20availability%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-713941%22%20slang%3D%22en-US%22%3ESee%20may%2C%20week%201%20for%20example%20of%20what%20I'm%20looking%20for.%3C%2FLINGO-BODY%3E
BYarbs90
New Contributor
I am trying to use an excel table to calculate employees that are already scheduled in a column, so that at the bottom I have a list of what employee resources are still available to be assigned.
So I have a very simple single sheet table with jobs sites in column A, rows 1-20 being a different site. Employees are in column B and assigned to jobs by row (b1-b20).
How can I assign a value to the employee names to get a running total at the bottom of employees that are available to put on jobs.
2 Replies
Please attach your sample file with manually entered results.
See may, week 1 for example of what I'm looking for.
Related Conversations