Remember Me?

#1
December 16th 16, 05:53 PM
 Junior Member First recorded activity by ExcelBanter: Jan 2014 Posts: 2
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!!
Attached Files
 Example.zip (13.8 KB, 30 views)

#2
December 16th 16, 07:10 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,466
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Stan Brown Excel Worksheet Functions 7 November 13th 11 04:43 PM Annie1904 Excel Worksheet Functions 3 November 28th 07 04:28 PM Mo2 Excel Worksheet Functions 3 March 30th 07 07:19 AM zangief Excel Programming 1 September 26th 05 08:13 PM Troi-Xanh Excel Worksheet Functions 2 February 12th 05 12:46 AM

All times are GMT +1. The time now is 06:23 AM.