R
Renee
I have a worksheet that lists employees, their locations & job titles. On
another worksheet I need a formula that counts the employees from each
locations dependent upon what group they fall in, ie. (mgmt, Administrative,
labor, etc.). The formula below works, but since I have so much criteria, I
run out of space.
Formula:
{=COUNT(IF(('Employees Works Sheet'!B1:B750="CALV ")*('Employees Work
Sheet'!D1750="Chauffeur I"),'Employees Work
Sheet'!A1:A750))+COUNT(IF(('Employees Work Sheet'!B9:B750="CALV")*('Employees
Work Sheet'!D1750="Laborer"),'Employees Work
Sheet'!A1:a750))+COUNT(IF(('Employees Work Sheet'!B9:B750="Crew
Leader"),'Employees Work Sheet'!A1:A750))}
See Ex.
Worksheet #1
Location Name Title
CALV Smith, A. Laborer
PUL Simms, F. Chef II
CALV Watson, T. Crew Leader
KEY HWY Jackson, G. Crew Leader
Worksheet #2
Location MGT CLERICAL LABOR
CALV
Formula results (2)
PUL
KEY HWY
MID-TOWN
Any help would be greatly appreciated
another worksheet I need a formula that counts the employees from each
locations dependent upon what group they fall in, ie. (mgmt, Administrative,
labor, etc.). The formula below works, but since I have so much criteria, I
run out of space.
Formula:
{=COUNT(IF(('Employees Works Sheet'!B1:B750="CALV ")*('Employees Work
Sheet'!D1750="Chauffeur I"),'Employees Work
Sheet'!A1:A750))+COUNT(IF(('Employees Work Sheet'!B9:B750="CALV")*('Employees
Work Sheet'!D1750="Laborer"),'Employees Work
Sheet'!A1:a750))+COUNT(IF(('Employees Work Sheet'!B9:B750="Crew
Leader"),'Employees Work Sheet'!A1:A750))}
See Ex.
Worksheet #1
Location Name Title
CALV Smith, A. Laborer
PUL Simms, F. Chef II
CALV Watson, T. Crew Leader
KEY HWY Jackson, G. Crew Leader
Worksheet #2
Location MGT CLERICAL LABOR
CALV
Formula results (2)
PUL
KEY HWY
MID-TOWN
Any help would be greatly appreciated