I work on a medical unit where I am building a unit tracker for patients. Currently I am using the formula:
=IF(ISNONTEXT('Daily Census'!C3)=TRUE,0,1)
to count the names and add them up in cell A2. The issue I have is sometimes we have to block a bed or room and use the work BLOCKED to identify it. However when I type it in, it counts it for the total count. I need to change the formula so it would count names but ignore the specified term "BLOCKED". Thanks for anyone who can help. Example below of how it looks set up.
Census PATIENT
5 Room
1 516-1 BLOCKED
1 516-2 Patient A
1 515-1 Patient B
1 515-2 Patient C
1 514 Patient D
So for 516-1 It says Blocked and is counting it with a 1. I would need it to exclude the word BLOCKED and say a 0. Again thanks for any help.
Bookmarks