Ugh! I was hoping to avoid such a long and difficult to maintain equation.
I've been looking at countifs, lookup, choose, sumifs, match, and sumproduct.
I had hoped there was a way to make Excel do the heavy lifting of walking
through a list and comparing the values it contains to another list and
summing the number of occurrences.


"Jim Thomlinson" wrote:

Sorry I could have been more clear. In general you will have one countif
function for each name in your source list. You will then just need to sum up
all of the individual counts... If there are 10 names in your list of source
names then you will need 10 countif functions and one sum function to add all
of the counts.
--
HTH...

Jim Thomlinson


"Mashuganah" wrote:

Thenks Jim. The problem is that the help file does not give an example of
how to structure the equation to compare against multiple text variables.
Help gives an example of using a single text variable and gives the
impression that I would have to enter each name in the equation which would
obviate the use of an array.

How do I structure a sumif equation to get the result I need?

"Jim Thomlinson" wrote:

Take a look at the sumif function in help.
--
HTH...

Jim Thomlinson


"Mashuganah" wrote:

I need to reference a list of names in a column in one worksheet to count the
number of times those names occur in a column in another worksheet in the
same workbook.

That is, check the name list and sum the number of times those names occur
in another list.

How do I do this?