I have searched, tired, failed. I am trying to count across multiple cells. For example, A is a name and D is a "problem". I want to see how often a person has that problem and countifs worked great. Now the problems are spread across C:H and it won't work. Is there a better function?
In this...