|I am creating a open items list for a project. Each row has a column for "Open" or "Closed". The section header has the same column, using an IF-OR statement, it depends on the open items in that section. If any item is open, the section header will state "Open". If all lines are closed the header will read "Closed". |
The issue I am having is that there is a variable number of rows for each section, and it is tedious to update the OR to include every new line added.
=IF(OR(G4="Open", G5="Open", G6="Open",G7= "Open",G8="Open", G9="Open", G10="Open")=TRUE, "Open", "Closed")
Is there a different way to say "If any of the cells from G4 to G10 = "Open" without having to write out each one? It would be much easier to change G10 to G13 rather than adding "G11="Open", "G12="Open","G13="Open".
Any help would be appreciated.