Progress, %, Status, Formula

[dude6571]

Hi,

I am looking for a formula that calculate a percentage of completion based on names.

XL sheet attached with expected outcome.

Many thanks
dude6571

[mikeava]

Let me know if this is what you need. I got a different result for your 3rd item % of Completion of Prod. Can you check that or am I missing something?

[dude6571]

Thank you so much Mikeava

[dude6571]

Your figures are corect

[mikeava]

Glad it worked.