Sum columns based on conditions
Hello,
I need to figure out how many "true" Regular employees we have. As you can see, I have columns that are labeled
FT, PT, REG, SEAS and INTERIM.
A FT OR PT employee can move from REG to INTERIM if they are filling in for another position. So technically, when they go from REG to INTERIM they are still considered a REG employee. Seas are truly seasonal emps and I dont need that info.
At the bottom of the sheet, I listed the columns I need...there will be conditions by site. I attached an example spreadsheet.
I hope this makes sense...thanks so much!!
|