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?