Hello,
I'm trying to create a simple document tracker,
It has a number of columns with Yes / No statements which track the document through its creation, issue and return from the client.
(F7) is document created status field
I'm using a cell to track the status of these fields
(M7) =AND(F7="Yes",G7="Yes", H7="Yes", I7="Yes", J7="Yes", K7="Yes",L7="Yes")
so the cell displays a 'True' or 'False' statement, (this shows the document as closed out / finished)
I'm hiding this cel and using another to display the same information but as a Yes / No statement
(N7) =IF(M7=TRUE, "Yes", "No")
I then have 2x cells counting the number of Yes / No from the N7 column,
The problem i have is if i copy the formula into cells that have empty or no statements in F7, N7 will show a No statement and the counter will still add it to the tally (so if 20x rows had the formula but i only had 10x docs of which 2x were closed, it would display 18x open on the tracker).
Is it possible to have an 'AND' statement in N7 that looks at F7 so that if it is showing "No" or "[BLANK]" then the cell is empty and the counter works as intended.
Or if there's another simpler way to do this im open to suggestions.
Any help is appreciated
Richard.
Bookmarks