LinkBack URL
About LinkBacks
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))
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))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks