SumProduct
On Sep 11, 5:10*pm, smartin wrote:
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.
The "trim" suggestion worked. I figured it was a leading or trailing
space, but other than going through each cell to eliminate it I wasn't
sure how to fix. Trim worked. Thanks to all!
|