What does your formula look like?

It should look like this (of course, adjusting the ranges to your own):

=SUMPRODUCT(--(A1:A100="smith"),--(B1:B100="john"))

Case is not a factor.

It's better to use cells to hold the criteria:

D1 = smith
E1 = john

=SUMPRODUCT(--(A1:A100=D1),--(B1:B100=E1))

Another possible cause is leading/trailing spaces or other unseen
characters.

smith<space
<spacejohn


--
Biff
Microsoft Excel MVP


"tonyalt3" wrote in message
...
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?