Ok,
so attached is a brief screen shot of what I'm working on. Essentially I'm trying to build a log / grading sheet for designers. essentially we have 17 "KPIs" or Key Performance Indicators we work on. They are typical grading for what you think designers would be graded on. They are also weighted so - While they get graded on 4 key areas - Quality, Process, Delivery, Satisfaction, Quality is more important than Process and satisfaction is more important than delivery etc.
The Scale -
[blank] = does not apply - these are for instances where the marketing coordinator (who doesn't use the design grades) is participating in a project that only SOME of the grades will apply. For those I'd like to leave OUT the score entirely thus not effecting the average.
0 = Fail
1 = Pass
2 = exceeds
What I need it to basically say (although I don't know how to write it) is - IF cells E9:G9 contain ANY numbers then average them, if they are all blanks then leave the AVERAGE cell BLANK (not DIV0 - because I need that cell OMITTED from the average calculation later like =average does.) basically my problem is that I'm getting DIV/O when I need a blank
This is what the sheet looks like -
So the issue is that I'll have 6 of these that are identical (one for each employee) that travel horizontally
I also need to have a monthly average at the bottom of this sheet for each person (it got cut off), and then as you can see, vertically down the left side each month with be added below the previous.
In the top portion I have a cell for the running average for each person.
ANYWAY, all of that stuff I have figured out, the main issue is the DIV/0 is breaking everything.
please help
I'd greatly appreciate it.
so attached is a brief screen shot of what I'm working on. Essentially I'm trying to build a log / grading sheet for designers. essentially we have 17 "KPIs" or Key Performance Indicators we work on. They are typical grading for what you think designers would be graded on. They are also weighted so - While they get graded on 4 key areas - Quality, Process, Delivery, Satisfaction, Quality is more important than Process and satisfaction is more important than delivery etc.
The Scale -
[blank] = does not apply - these are for instances where the marketing coordinator (who doesn't use the design grades) is participating in a project that only SOME of the grades will apply. For those I'd like to leave OUT the score entirely thus not effecting the average.
0 = Fail
1 = Pass
2 = exceeds
What I need it to basically say (although I don't know how to write it) is - IF cells E9:G9 contain ANY numbers then average them, if they are all blanks then leave the AVERAGE cell BLANK (not DIV0 - because I need that cell OMITTED from the average calculation later like =average does.) basically my problem is that I'm getting DIV/O when I need a blank
This is what the sheet looks like -
So the issue is that I'll have 6 of these that are identical (one for each employee) that travel horizontally
I also need to have a monthly average at the bottom of this sheet for each person (it got cut off), and then as you can see, vertically down the left side each month with be added below the previous.
In the top portion I have a cell for the running average for each person.
ANYWAY, all of that stuff I have figured out, the main issue is the DIV/0 is breaking everything.
please help
I'd greatly appreciate it.
