I am trying to develop a counting tool that allows us to track results related to some survey questions. To be eligible to be counted three criteria questions must be answered with a Yes (blue shaded cells). Then a service is either provided or not (Y or N). However, there are three exclusionary criteria that allow the respondent to be counted as if they received the service (green cells).
The attached worksheet shows how I've "counted" everything so far. I’m only interested in Eligible clients. My question is how can I keep track of only eligible patients and those who meet the exclusionary criteria. Is it possible to restrict entry on the green cells to just one answer (either a Y or N) or restrict entry if they do not meet the eligibility requirements of a 3? Notice the false failure in row 12 – I’m also trying to eliminate theses.
I then need to calculate the success and failure on the eligible clients (yellow cells).
Or is there a better way to count and calculate this data?
Any help is appreciated.