Is this possible with SumProduct?

Hi,   I have a worksheet that looks something like this:     x A B C D E F 1 # of units Tom Jerry Rachel Sarah Sam 2 1 Apple Apple Pear Orange   3 3 Banana ...