michaelrjb
08-28-2013, 08:47 AM
Hi All
I have a workbook that shows the RAG status of a number of projects i am working on.
The 'Detailed' Worksheet has a 50+ projects in it, each with a number of objectives for each project.
The 'Summary' worksheet lists all the project and an indicator (RAG) showing how many objectives have been met for that project. So if an objective is below 70% complete it should tally 1 to the Red status, over 80 tally to yellow and over 90% tallies to green.
I tally all these up by hand, and i'm hoping there is some quick SUM statement that will give me a figure of the number of objectives that are at green.
So for the W7 Deployment Project, it may have objectives such as 'Deploy to Site 02' on 'Detailed:B3' @ 98%, 'Deploy to Site 03' in 'Detailed:B4 @ 56% and 'Deploy to Site 04' on 'Detailed:B5' @ 91%, so the Red Status on 'Summary' should be 1, and the Green 'Status' should be 2.
Thanks for any help.
10513
I have a workbook that shows the RAG status of a number of projects i am working on.
The 'Detailed' Worksheet has a 50+ projects in it, each with a number of objectives for each project.
The 'Summary' worksheet lists all the project and an indicator (RAG) showing how many objectives have been met for that project. So if an objective is below 70% complete it should tally 1 to the Red status, over 80 tally to yellow and over 90% tallies to green.
I tally all these up by hand, and i'm hoping there is some quick SUM statement that will give me a figure of the number of objectives that are at green.
So for the W7 Deployment Project, it may have objectives such as 'Deploy to Site 02' on 'Detailed:B3' @ 98%, 'Deploy to Site 03' in 'Detailed:B4 @ 56% and 'Deploy to Site 04' on 'Detailed:B5' @ 91%, so the Red Status on 'Summary' should be 1, and the Green 'Status' should be 2.
Thanks for any help.
10513