Excel 2007 : Change Text of Cell based on Multiple Values

Hi Folks,

Hopefully you guys can help since I've got a bit stuck -

BACKGROUND -
Got an exit criteria spreadsheet, with multiple 'States' or lists ..

Section 1 Complete | Then list whether Completed/Not Done/In Progress etc

The criteria themselves have become massive and very long so I intend to break it up into groups which is where I become stuck.

Once I've used the Excel's Group function containing that particular Group's criteria I created a row above them all to show if everything within it was completed or not.

MY ACTUAL PROBLEM -
If possible, is there a way that if everything is marked as completed, then this top row's state will change to show 'Completed' automatically?
Then if anything is still outstanding then it should still state 'Not Done'.

I've attached screenshots of the mockup I've been working on if it helps anyone.

Thanks in advance.