+ Reply to Thread
Results 1 to 4 of 4

Productivity Calculation

Hybrid View

  1. #1
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Productivity Calculation

    It's not clear exactly how you want it to look, but you could use something like the table in my attachment, which uses:

    =IFERROR(INDEX($F$2:$F$50,SMALL(IF(COUNTIF($H$2:$H2,$F$2:$F$50)=0,ROW($F$2:$F$50)),ROW(1:1))-1),"")

    ...filled down to return the names. The formula should be array-entered (Ctrl + Shift + Enter). Then the following for the data:

    =COUNTIFS($F$2:$F$50,$H3,$C$2:$C$50,">="&$I$1,$C$2:$C$50,"<="&$K$1,$D$2:$D$50,I$2)

    Fill right and down. See the attachment for a clearer picture:


    EDIT: You can change the dates in row one to select a different date range
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lab Productivity
    By omer123456 in forum Excel General
    Replies: 13
    Last Post: 12-23-2015, 04:06 PM
  2. employees production and productivity calculation
    By Giri.hb in forum Excel General
    Replies: 4
    Last Post: 06-29-2014, 10:04 AM
  3. Productivity
    By mmitri in forum Excel General
    Replies: 3
    Last Post: 09-24-2012, 07:50 PM
  4. Productivity calculation
    By genichigo in forum Excel General
    Replies: 2
    Last Post: 05-23-2012, 04:48 PM
  5. Shift Productivity Calculation
    By Kheldar in forum Excel General
    Replies: 1
    Last Post: 02-03-2011, 02:10 PM
  6. Calculation of Productivity
    By roshan.sayed in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2008, 10:18 AM
  7. productivity calculation
    By Tanglefoot in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2006, 11:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1