Solved

# Calculating percentage of work load in grid

Posted on 2013-09-16
Medium Priority
177 Views
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!
Book2.xlsx
0
Question by:Mamarazzi

LVL 54

Accepted Solution

Rgonzo1971 earned 2000 total points
ID: 39496051
Hi,

pls try

=SUM(B5:G5)/SUMIF(B5:G5,"<>",B10:G10)

Regards
Copy-of-Book2.xlsx
0

Author Comment

ID: 39496079
Thank you, Guru! :-)
0

## Featured Post

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.

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â€¦
###### Suggested Courses
Course of the Month13 days, 10 hours left to enroll