Calculating percentage of work load in grid

Posted on 2013-09-16
Medium Priority
Last Modified: 2013-10-09
Help with Excel formula needed!

I want to calculate percentage of normal workload for a number of resources. The percentage should be calculated using a normal workload for each month and actual for each month and resource. See example file!

Zero in cell means that resource didn't work at all, and empty cell means that I just didn't fill in value yet so that month shouldn't be included.

The percentage shown in col H should be the total per resource. For example for Name 1, 62% (hardcoded in file).

The trick for me is that I only want to include cells with value in rows 5 - 7 and corresponding normal values in row 10. Remember that zero is a value!
Question by:Mamarazzi
LVL 54

Accepted Solution

Rgonzo1971 earned 2000 total points
ID: 39496051

pls try



Author Comment

ID: 39496079
Thank you, Guru! :-)

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question