Hello MrExcel Community!
Thanks in advance for all of your input, I always seem to get a great response to my questions here.
So I have created a table, that looks at a live feed and measures staff on the completion of their projects. The projects are split into two groups BAU and non BAU, I then calculate their over all percentage of completion for both groups. I would like to combine these percentages however I cannot get the sum to take into consideration that some values may be "0", and if so, no further calculation would be needed.
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL span=3><COL></COLGROUP>
Above is come example data...
So in the total percentage column, i would want results that for Mark and John, take into consideration they have "0" for some projects, and thus do not divide by 2, but for Matthew and Luke, do divide by two as there are two entries.
75% for Matthew
95% for Mark
67.5% for Luke
& 80% for John
Do let me know if I am trying to do this the long way round!
Once again thanks for your time, I look forward to reading your responses.
Wilson
Thanks in advance for all of your input, I always seem to get a great response to my questions here.
So I have created a table, that looks at a live feed and measures staff on the completion of their projects. The projects are split into two groups BAU and non BAU, I then calculate their over all percentage of completion for both groups. I would like to combine these percentages however I cannot get the sum to take into consideration that some values may be "0", and if so, no further calculation would be needed.
| # BAU Projects</SPAN> | # Non-BAU Projects</SPAN> | Total Projects</SPAN> | BAU %</SPAN> | Non-BAU %</SPAN> | Total %</SPAN> | |
| Matthew</SPAN> | 1</SPAN> | 1</SPAN> | 2</SPAN> | 100.00%</SPAN> | 50.00%</SPAN> | |
| Mark</SPAN> | 2</SPAN> | 0</SPAN> | 2</SPAN> | 95.00%</SPAN> | 0.00%</SPAN> | |
| Luke</SPAN> | 3</SPAN> | 2</SPAN> | 5</SPAN> | 75.00%</SPAN> | 60.00%</SPAN> | |
| John</SPAN> | 0</SPAN> | 3</SPAN> | 3</SPAN> | 0.00%</SPAN> | 80.00%</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL span=3><COL></COLGROUP>
Above is come example data...
So in the total percentage column, i would want results that for Mark and John, take into consideration they have "0" for some projects, and thus do not divide by 2, but for Matthew and Luke, do divide by two as there are two entries.
75% for Matthew
95% for Mark
67.5% for Luke
& 80% for John
Do let me know if I am trying to do this the long way round!
Once again thanks for your time, I look forward to reading your responses.
Wilson
