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?