We have a worksheet that tracks approx 400 applications and each application
can have up to 30 project plans.

We track the status of each plan (ie completed, n/a, open, or a blank value
means a plan is not expected). There are 30 plan status columns per
application starting in column C.
For example, the 1st application may have Plan #1 Status as "open", Plan #2
status as "N/a", Plan #3 Status is blank, Plan #4 status as "completed", etc
etc etc up to approx 30 status columns.

I would like to a quick way to automate an overall summary status for each
application. If any of the status's are "open", then the overall status
should be "open". If all are "completed" or "N/a" or blank, then the overall
status should be "completed".

Without doing a huge IF/AND/OR statement, is there an easy way to sum this
up? By arrays perhaps?