Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 16th 16, 06:53 PM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2014
Posts: 2
Default 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
File Type: zip Example.zip (13.8 KB, 30 views)

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Largest value in column A based on conditions in columns B and C Stan Brown Excel Worksheet Functions 7 November 13th 11 05:43 PM
COUNT based on conditions in 2 or more columns Annie1904 Excel Worksheet Functions 3 November 28th 07 05:28 PM
shade cells based on conditions - i have more than 3 conditions Mo2 Excel Worksheet Functions 3 March 30th 07 07:19 AM
returning values from columns to another sheet, based on conditions zangief Excel Programming 1 September 26th 05 08:13 PM
count number of cells based on TWO conditions (2 different columns Troi-Xanh Excel Worksheet Functions 2 February 12th 05 01:46 AM


All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017