This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to determine how to count the number of times a name occurs across multiple columns. The columns will differ in length which will change over time. In my excel example below you will see that there are names in columns A B C and the count column has two names. What I would like to do is count the number of times each name in the count column occurs in columns A B or C.
So in this case, would like a 2 for Mike and 1 for John.
I assume there is some sort of function that could be put in the formula tool but I can't seem to find a viable solution.