+ Reply to Thread
Results 1 to 12 of 12

Productivity Percentage Formula

Hybrid View

  1. #1
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Productivity Percentage Formula

    This might be what you're after:
    Sum percentages (B18:F18)
    Divide that total by regular hours worked that are greater than 0:
    = SUM($B$18:$F$18)/SUMPRODUCT(--($B$17:$F$17>0))

  2. #2
    Registered User
    Join Date
    04-19-2011
    Location
    Arizona
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Productivity Percentage Formula

    Ok used to your formula however the #div/0! is still there and as a result it will not total the % row. so for example on that same sheet i put 0 for hours worked and 0 for billable hours and got the above error due to dividing a number by 0. The % row is formula based on dividing row 16 by row 17. I put the formula you gave me in to total column on the % row. if there is a number in there then it works fine. I also tried the #n/a but it still has the same result.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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