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!!

Sum columns based on conditions
 

Hi,

Am Fri, 16 Dec 2016 17:53:04 +0000 schrieb shani1975:

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.

what is the difference between OCC ON SITE and OCC REMOTE?
Try in H62:
=SUMIF($B$1:$B$59,LEFT($G62,3),INDEX($H$1:$L$59,,M ATCH(H$61,$H$1:$L$1,0)))
and copy down and to right.


Regards
Claus B.
--
Windows10
Office 2016