3 Replies Latest reply on Jan 22, 2019 6:54 AM by Moses Dhas

    Get Count and Sum by User Defined Categories

    Moses Dhas

      Hi,

       

      I got an excel spreadsheet that has employees with number of hours worked for each time period. The badge number is repeating because the employee has worked on multiple days. i would like a report that is categorized like below

       

      0 - 2021 - 4546 - 60More Than 60Total
      Head Count9027213987912551
      Hours1,04810,22477,58254,568143,422
      Men1717012939092390

       

      Head Count = Total number of unique badge numbers that worked between 0 to 20 hrs, same for 21 - 45, 46 - 60 and more than 60

      Hours = Total number of hours than employees have worked between 0 to 20 hours, same for 21 - 45, 46 - 60 and more than 60

      Men = Hours / 60

       

      the 60 should be a parameter cos it can be 50 or 70 or 80 based on the requirement.

       

      attached is the excel file. sheet Summary, rows 41 to 45 is the output data.i would like the above table to be calculated only from the Yard man-hours sheet.

       

      thanks for any assistance that can be provided.