tonyalt3 wrote:
I am trying to look up how many times a person is listed on a
worksheet. They are listed as lastname, column A and first name,
column B. I've been doing a "sumproduct" function, however for some
reason it doesn't count some individuals. I KNOW everything is
spelled the same and has the same amount of caps. Any ideas of what
is wrong, or how else to run the function?

The case (caps, not caps) doesn't matter (try it) however if there are
any leading or trailing spaces in the name the match will fail.