I am trying to figure out how many employees get several different shift differentials or premiums based on the following list:
The first column lists the department code where the third and 4th columns list if that department gets both nite rate and cooler rate premium. As you see, some dept.s only get cooler, some only get nite, but some get both cooler and nite.
On a separate Tab called NEW BID in column G starting in row 5 with the first employee, is where it contains the departments per above list that employees are designated.
I'd like to do a count of how many employees are receiving cooler rate, how many are receiving nite rate, and how many are receiving BOTH cooler and nite rate. I was going to have those counts in 3 separate cells. What formulas could I use based on this info?
The first column lists the department code where the third and 4th columns list if that department gets both nite rate and cooler rate premium. As you see, some dept.s only get cooler, some only get nite, but some get both cooler and nite.
On a separate Tab called NEW BID in column G starting in row 5 with the first employee, is where it contains the departments per above list that employees are designated.
I'd like to do a count of how many employees are receiving cooler rate, how many are receiving nite rate, and how many are receiving BOTH cooler and nite rate. I was going to have those counts in 3 separate cells. What formulas could I use based on this info?