Forum Discussion
blank form, count if cell is not blank and is = to a cell
Hi, I have created a blank form to be filled out by my clinic workers. and as they fill in the Provider field I need it to count all the Provider fields (ie: d3:d44) that are in d3, d4, d5 as we ...
I'm looking at your form and having a difficult time visualizing what should be happening. Could you describe what you're expecting a clinic worker to fill in here (perhaps even filling out one of the forms)...and what then should be appearing in column E?
It looks as if you are wanting the count of patients seen by each provider, but I'm not sure. Nor am I sure that this would be the way to do it. But let's start with what the goal is.
Can I also ask what version of Excel you're using? There are some newly available dynamic array functions that might be the solution.
And are you wedded to this format? Might it be acceptable to have the number of patients seen by each provider at each location appear off to the side of this input form?