Piecing together this message and your initial one I think you would like
the 5 cells to have one of three values "Open", "Closed", or "Unprocessed"
You then want one cell that checks the 5 cells for EITHER the Open or
Closed. If none of the cells have Open or Closed then the one cell should
read "UP".

The one cell's formula could be modified to read:
=IF(COUNTIF($B$1:$B$5,"=Unprocessed")=5,"UP","DOWN")

Is that more what you are looking for? How does the fact that one workbook's
value is Open or Closed change things? Do all of them need to read Open
and/or Closed at the same time? Or are you asking how to write the formula
for the 5 reference cells?