Forum Discussion
blank form, count if cell is not blank and is = to a cell
Take a look at this. See if it does what you're desiring. Try adding a name or two, repeating them. You'll see that the summary report on the right grows with each added name, and keeps track of the total count for each name. This solution does use the Dynamic Array functions FILTER and UNIQUE and SORT (all put together in one formula)...so if you don't have the most recent Excel, it likely won't work. In which case, I'd recommend getting it (via subscription to Microsoft 365).
Now, to avoid problems with spelling, etc., you might want to use data validation so that there's a drop down list of acceptable names for each location. That's another topic.
actually, we need to count on providers and not count if provider is blank and not have it accumulate in "blank" counts
If that was meant as feedback based on what I gave you, it isn't clear what you're saying. So far as I can tell, it does give you a count of providers and not blanks.
It would also be helpful if you answered the questions I asked. Like what version of Excel are you using? It's possible that you're using something other than the most recent version, in which case your feedback may be caused by that--you're not seeing what you'd be seeing if you were using the most current version.
This is what it looks like with a current version of Excel. If that's not what you're seeing, let me know. The summary report area will grow as additional Providers add their rows, but it will always show any one provider's name but once, with a count of how many patients that particular provider saw.
