Tuesday, November 19, 2013

yogi_Count Instances Of Clerks And Shipping Employees Working In Specified Shifts From Coded Data

                                          Google Spreadsheet   Post  #1424
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 19, 2013
question by JFC1111 (http://productforums.google.com/forum/#!mydiscussions/docs/ZcGR3JpsmYA)
I would also like to be able to count the number of positions filled for each shift, and include this information in one cell I think using the concatenate function (clerks/shipping/other) would look like 4/2/1. What I can't wrap my head around is that some of the codes will be the same for each position, as well as codes that are for sick and vacation etc(which should not be counted). My thinking is that the formula will lookup what the "position code" is, and reference the corresponding date cell to see if a "shift code" is present. If true then count all for that "position code" and do it again for the next "position code" and combine all the totals using concatenate. 

Thanks so much